SQL Server

Page 2849




  • Topics
    Replies
    Last post
  • SQL Execution Error: "clr Enabled"
    by Samer Selo
    2 Replies
    Last post by Samer Selo
      • I've Created a DLL Library and added it as an assembly in a database when I make a select statement from SQLCmd using my functions it runs fine but when I try to Create View from the VB 2005 Express Development Environment it Gives me the Error SQL Execution Error Error Message: Execution of user code in the .net Framework is disabled. Enable "clr Enabled" configurartion option
  • Migrate from old SQL ce Version in to new SQL Server/mobile
    by Miguel Pires
    3 Replies
    Last post by ErikEJ
      • Hi all, I'm in a middle of a server migration, Old server: SBS 2003 sp1 with SQL server 2000 and SQL server CE New server: SBS R2 with SQL server 2005 and SQL server mobile I have tried to find on internet how to migrate all my databases that i have on old server in to the new one, but i can't find anything on it. In old server i have replic
  • SQL Server 2005 SP1 Failure - 'dm_exec_query_resource_semaphores'
    by Kasemchai
    2 Replies
    Last post by greg anson
      • Hi Sam, In my case, the components in sp1 were installed successfully except the database engine. And the following messages were captured from the setup log. Please advise me. Thank you in advances, Kasemchai ---------------------------------------------- Action start 15:24:23: CommitSqlUpgrade.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> MSI (s) (5C!
  • Rebuilding System Databses
    by domw001
    4 Replies
    Last post by Patrick Roberts
      • I have just spent 2 days trying to rebuild my system databases after a crash. Each time I issued the start /wait setup.exe etc . command, the task would fail with the error: MSI (s) (80:10) [12:07:34:815]: Product: Microsoft SQL Server 2005 -- Error 1706. An installation package for the product Microsoft SQL Server 2005 cannot be found. Try the installation again using a valid copy
  • SQL 2005 fails to install workstation components and tools
    by Jean LeFrancais
    8 Replies
    Last post by Jean LeFrancais
      • Hello. When I install SQL Server 2005, it all goes well except that it fails to install these two: - SQLXML 4 - workstation components and tools When I try to install these two from the CD in the Setup folder of the CD 2 with the files sqlxml4.msi and sqlRun_Tools.msi (if I remember these names correctly), it gives me an error: 'Ce package d'installation n'est pas pris en charge par
  • Hide Database Design
    by Touraj
    4 Replies
    Last post by Markus Sch.
      • Hi I wanted to see if Microsoft was going to address this problem We as developers want to hide our database design (SQL Express DB) We dont want to rely on the user rights settings to secure the design Most of our clients have admin access which means that they can see the db design We are happy for the design to be available on the server as change control should be given only on
  • Moving whole rows in the script component
    by Hubajube
    5 Replies
    Last post by Hubajube
      • I am new to script components. I would like to make a simple filter that either passes a row through untouched or eliminates it. I have my input and output buffers set the same, and I have it set as asynchronous. Now these are big rows. Is there a painless way to copy all columns from the input to output buffer, or do I have to do a "Output0Buffer.Col1 = Row.Col1" for each column
  • Trigger a delivery directly
    by Michael23
    2 Replies
    Last post by Michael23
      • I have a delivery extension that prints to network printers. Now I add a subscription like a few minutes in the future via web service for each report to print. Is there a way I can trigger the delivery directly Thanks for ideas, guys. Michael
  • Release of JDBC driver 1.2 final version
    by Jeff Hobeck
    1 Replies
    Last post by Riyaz Habibbhai - MSFT
      • Just wondering when the final (non-QA) version of the SQL Server 2005 driver is expected to be released. Thanks. Jeff
  • DefaultCodePage issue from Db2 source
    by enric vives
    3 Replies
    Last post by enric vives
      • Hi everyone, We're stuck with this. We've got a Db2 source connection and when we try 'Preview' button appears the following error: TITLE: Microsoft Visual Studio ------------------------------ The component reported the following warnings: Warning at {420E9420-175B-4C2F-856A-EA5D51C23627} [OLE DB Source [1]]: Cannot retrieve the column code page info from the OLE DB provider
  • Error: 17189, Severity: 16, State: 1
    by Nik_MI
    0 Replies
    Last post by Nik_MI
      • We have WIN 2003 with SP2 hosting Sql Server 2005 with SP1, and we had a problem where no one was able to log-on, tried DAC as well, the sql error log showed the following severity error 17189, Severity: 16, State: 1. In one of the related thread it is suggested to update the TCP/IP paramter in the registry. Is that a permanent fix for the problem or Service Pack 2 for Sql Server 2005
  • How can I rename my ReportServer databases?
    by Pat Brickson
    6 Replies
    Last post by Pat Brickson
      • Hi, I am trying to move my Reporting Services databases from one server to another one. On the old server there was only a single instance so my databases were named ReportServer & ReportServerTempDB. On my new server I have multiple instances and, after installation (which I didn't perform), the databases on the new server are ReportServer$SQL_VS11 & ReportServer$SQL_VS11TempDB.
  • Deploying a report
    by Kiranvukkadala
    5 Replies
    Last post by ngk
      • I am new to Reporting services and have created just a layout page. no datasets or data sources are present. This is just a cover page. I need to show this page through a url. Can i deploy this on my local machine rather than showing some-one through the preview mode. What would be the local host configuration settings. Thanks.
  • What happend with NS in 2008?
    by SarxMX
    5 Replies
    Last post by AmitGoyal
      • The cuestion is because now i¡¯m trying to implement NS for my aplicactions but i¡¯m afraid it is not supported in 2008 (or newest version)... at this moment Technet talk only about NS 2005... someone have information about NS 2008 This is the driagram form Sql Server 2008... http://msdn2.microsoft.com/es-mx/library/ms159106(sql.100).aspx Where is NS 2008 Thanks
  • subscription error- rsServerConfigurationError
    by Lenaa
    4 Replies
    Last post by Amul Pandya
      • Hi, I created a report and am testing the data driven subscription to email it to myself. It is processed with 1 error. The status says "rsServerConfigurationError". I opened the log file and it says GetPermissions:<the report name> Call to GetSystemPermissions does this mean i don't have enough permissions I'm the admin in the server. What else do i need Any idea
  • What is the best way to compute the value of XQuery position()?
    by Deepak Puri
    2 Replies
    Last post by Martin Honnen
      • This issue arises from a current limitation in the usage of position() to within a predicate in SQL Server 2005 (if I interpreted the earlier discussion threads correctly). In my scenario, I need to shred a sequence of XML elements (actually, menu selections in a call); but need to include the position/sequence number for each element as well, when saving them to a relational table.
  • SQLServerAgent Rights
    by mipe10
    3 Replies
    Last post by ggciubuc
      • Hi, I have a problem that concerns the abillity to specify rights to edit and run one or more jobs in SQL Server 2005. What a want to accomplish is to let one or more users edit a job and run it. As far as i can see that isn't possible since the user that want's to edit the job has to own the job, and only users can own a job and in that case more than one user won't be able to run the job. It'
  • what is the difference between updating null value Vs empty string to varchar/char field?
    by Vidhura
    6 Replies
    Last post by Sean Fowler
      • Hi, What is the difference updating a null value to char/varchar type column versus empty string to char/varchar type column Which is the best to do and why Could anyone explain about this Example: Table 1 : tCountry - Name varchar(80) nullable Table 2 :tState - Name char(2) nullable Table 3 :tCountryDetails - countryid,state (char(2) nullable) - May the country cont
  • Need help with XML output to file
    by Danny63
    4 Replies
    Last post by Danny Meyer
      • I'm using SQL Server 2005 / 9.0.3042 I'm not new to sql server, but making my first experience with xml in sql server 2005. I have a query like this (based on <Table> with neccessary data): SELECT TAG, PARENT, <columns...> FROM <Table> FOR XML EXPLICIT This query creates a xml file exactly as i need it when i execute it in Management Studio. Well
  • Express SP2 install error
    by Tyodotnet
    3 Replies
    Last post by Tyodotnet
      • Hi, try to install (not an upgrade) SQLExpressSP2 on WinXPSP2 from SQLEXPR32.exe package. .NET version 2.0 is already installed however get error below before last step of Server setup ( Excerpt from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_ISD02_Core(Local) ): </------- START OF Excerpt ---------> <Func Name='PerformDetections'> 0 <En
  • Deployement to a local machine
    by tchouny
    1 Replies
    Last post by Arnie Rowland
      • Hi, I have developped a program with VB 2005 with a DB using sql server and I would like to know if I use this program on another computer what's the minimum requirement. Dotnet 2.0 and sql server But do I have to install the full sql server version or just a patch to be able to run that kind of program Thx in advance
  • programatically create a DSN for SQL-Server with non-standard port-number
    by Franz585421
    5 Replies
    Last post by tosc
      • Hi all, I have to create a DSN for SQL-Server. Therefor I use the function "SQLConfigDataSource" from "ODBCCP32.DLL". But the problem is that the SQL-Server does not use the Standard-Portnumber 1433. I've tried to make the DSN with "SERVERNAME xxxx" where xxxx is the Portnumber, sometimes it works, but often it does not. When it does not work, then the Checkbox
  • Dynamic T-SQL Query Creates Table At Run time.
    by Dwight Kulkarni
    5 Replies
    Last post by Mandip
      • The following are the output lines from my code which is constructing some T-SQL queries on the fly. The query highlighted in yellow is the problem query. The code upto the problem query is working correctly and I am able to see the output tables in the Query Analyzer STEP 1 : Create 3 Tables In Dynamic T-SQL : Showing 3 Strings from Exec statement Create Table ##Test_word28July20071855
  • Regarding SQL Server Reporting Services - Deployment of Reports
    by rolliet
    5 Replies
    Last post by rolliet
      • Hi All, I am new to SSRS. I have installed Reporting services and configured the report server. But i keep getting error messages when i try to deploy the report. I am not able to see the report in SSMS either. The error says it is not able to connect to the report server. Could anyone please help me It is quite urgent Thanks
  • Common Generation Watermark error for Merge Replication
    by John123
    14 Replies
    Last post by Tom Romanul
      • Hello, We have a sqlexpress subscriber that is receiving the error below. SQL Server 2005 We have tried: Generate new snapshot. Reinitialize the subscription. Dropped the subscription. Reboot the web server box. Reboot the sql server box. Yet we still get the errors for these specific subscribers. Any ideas Error in replication monitor.... Error messages: