Hi All I have a table setinfo(int seqid, int setid, varchar(75) mystr) Data is like this.. 1,1, 'ab|bc|cd|xx' 2,1, 'pq|dq|mq' 3,1, '11|22|33|' 4,2, 'ab|bc|cd|xx' 5,2, 'pq|XX|mq' 6,2, '11|22|33|' I have to write a stored procedure, which will identify what is different between 2 set...more >>

Hi , i have read this KB but this applied also to SQL with AWE enabled for more then 4 Gbyte ? http://support.microsoft.com/kb/924054 Thanks ...more >>

Hi ! i have a SQL 2000 A/P cluster with 4 CPU ancd 8 GByte with AWE enabled; my db as work fine but from same day a error was dispaly in my application log : Event Type: Error Event Source: MSSQLSERVER Event Category: (2) Event ID: 17052 Date: 28/07/2006 Time: 9.32.02 User: N/A C...more >>

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition with SQL 05 SP1. try to launch Database Tuning Advisor from the Tools, then got the following error message box: "Microsoft Visual C++ Runtime Library Runtime Error R6031 - Attempt to initialize the CRT more than once. This i...more >>

we have 64 bit SQL 2005 Ent edition on x64 bit Win 2003 Ent edition with SQL 05 SP1. I tried run one of our sql 2000 dts package using SSIS "Execute DTS 2000 Package Task", running debug mode, got the following error message: SSIS package "TestDTS.dtsx" starting. Error: 0x0 at Execute DTS 2...more >>

Hi there, I use detach, then attach method to convert databasae to sql 2005, by default, it is under compatibility level 80, my question are: 1. Does the database performance degrade when it is running comp level 80? I know you cannot take advantage of new feature of sql 2005, but do you h...more >>

Folks, I cannot seem to find anything with good documentation on this. I've got a SBS 2k3 server w/ SQL 2k Std. I backup my DB nightly to the HDD (mirror array) and my transaction logs from 7a-8p. However. I've yet to find a decent way to mirror these backups (both nightly and hourly) to ...more >>

Hi I have a web page where users insert some comments into a text area. users are able to insert any character into this area. When they submit the character ' and " causes problems. How can i allow these characters to be inserted into the database( sql server 2000)? I am using Java ser...more >>

Hello! I discovered following error message on our production x-64 bit SQL Server 2005 cluster: ' Message The server was unable to load the SSL provider library needed to log in; the connection has been closed. SSL is used to encrypt either the login sequence or all communications, depen...more >>

Hello, I'm trying to benchmark a SQL database that contains only one table. I'm running SQL Server 2005 x64/Windows 2003 x64 on a machine with 1GB of RAM and One CPU (AMD Athlon 64 3200+ 2Ghz). All the queries against the database ends in only one table that contains 1000 records. There ar...more >>

Sorry, I need to run backups to a shared drive on another server, and everything I have tried for the last hour will not work.. I have full access to the drive, can copy and paste anything into it, but when I run this Query BACKUP DATABASE ArnesPriceBook TO DISK = 'L:\ArnesPriceBook_db.BAK' ...more >>

Hello, I'm trying to run the stored procedure found in this white paper from Microsoft. However, after correcting the stored procedure "add_column" which do not compile at first, it seams that "get_indexstats" generates a wrong SQL Query for execution : the second query fails with "Msg 10...more >>

Is the tempdb, or could the tempdb be used in backup processes, such as when I issue a statement to backup a user database: BACKUP DATABASE MyDb TO DISK = c:\mydb.bak' -- Message posted via http://www.sqlmonster.com ...more >>

I have a two tables: Users Table: UserName Security usr1 grp1,grp2 usr2 grp2 usr3 grp3 Menus Table: Name Security ABC grp1,grp3 DEF grp2 XYZ grp4 I want to display usr1 menus. declare @s varchar(50) set @s = (select...more >>

Hi all - A process we've identified has generated over 1000 connections to a DB which are now in a "sleeping" state. Is there some way to disconnect all sleeping connections w/out having to kill each one individually. I am trying to avoid having to stop/restart the SQL service to remove...more >>

Hi all, I need to convert a value in hexadecimal to varchar, and this does not seem to be as easy as DECLARE @hex varbinary DECLARE @str varchar SET @str = 'test' --PRINT @str SET @hex = 0x0000000000000001FFFF07D600002710 SET @str = CAST(@hex as varchar) Any ideas? Has anyone tried t...more >>

I need to write query or stored proc that is going to be used to gen. a report This is a structure of my table Id Date ItemType OrdersPlaced 1 08/21 1 100 1 08/21 2 500 1 08/21 3 200 1 08/21 ...more >>

I have some fields I want to populate in table one depending on the data from table two. How would I do this. I understand I need to use the Update,Set,Where but how do I use two tables? ...more >>

I have a scheduled task that runs a batch file in windows 2003 server which is running SQL Server 2000 Enterprise. The batch file contains the line: OSQL -i myscript.sql -Umyuser -Pmypassword -Slocalhost -o mytrans.log the 'myscript.sql' file updates a table with another table of the exac...more >>

Maximum Capacity Specifications for SQL Server 2000 on Windows server 2003. The information I am finding is information on Windows server 2000. That is old and outdated information; I need information for SS 2000 editions on 2003 editions of windows. Please direct me to an article or table...more >>

Hello, I have a table T1 with ID and Desc fields. I want to export this table to excel files based on the ID field. So my stored procedure select all the same T1.ID and export it to ID.xls files. How can I do this? ...more >>

Hi When I don't use SQL Server , my otherwise idle CPU is spiking every (Roughly) 10-15 seconds and when I look in the profiler, a lot of internal queries are executed all the time. Queries like these ones are executed on most of my tables. exec sp_spaceused DBCC SQLPERF(LOGSPACE) sel...more >>

We are running SQL 2000 SP3 on our 2003 Server (SP1 with latest updates installed). The SQLSERVER agent does not start up automatically after reboot or power up of server. The agent is set to automatic in services and in SQL2000. The logon account is set to local system account. The server is...more >>

Hi Friends, I want to know how disaster recovery work? It means What are the types of Disaster why we planned for the recovery asn all those stuffs. Please explain me briefly. Thanks, Manu ...more >>

Hi *.* I've a problem with my query, perhaps you professionals can kindly Help me to overcome this, let me explain the problem, We have an Inventory software with about 8500 of Goods (we stored it in table Called tblPart), every input/output of these Goods saves in a Table Called tblInvRate,...more >>

What is the best way to backup SQL server, I mean through SQL Server maintenance plan or using a 3rd party software (Veritas netbackup) Thanks...more >>

Hello, I am looking for a process where by I can transfer Outlook data (Emails) into SQL Server 2000 \ 2005 for certain urgent analysis. Can some one please explain me how to accomplish this task? Thanks in advance. Surajit ...more >>

Hello, i can't find the connection string (and the def of the options) to access a flat file from SQL Server 2005. I guess it is something like: Provider=Microsoft.Jet.OLEDB.4.0; Data Source=MyFlatFile; Extended Properties=... etc.etc Can anyone help me? Thx, Chris ...more >>

I am using SQL server 7.0. After restoring all the databses (Except distribution) Everything seems to be working fine except the backup maintenance plan. I put following detail in the maintenance plan "General Tab: Plan Name ---> DB Maintenance Plan1 () All Databases Optimizations tab: ...more >>

I have a server with a total of 4G ram, using Windows 2003 Server Standard and SQL Server 2005 Standard. I have set SQL Server to use a maximum of 2048M ram, this is also the maximum that the standard edition can use, however for some reason it never reservs more than 1.6G, no matter the loa...more >>

What is the difference between key and index? Thanks. ...more >>

Hi, In my SQL Server 2000 MyDataBase's TableA, TableA has 4 columns, and there're 6 rows as: A 1A A 12345 A 1A AA hjklhkl A 1A AAA uiopuo B 2B B dfdgh B 2B BB 123789 B 2B BBB 14uio Now how do I select ...more >>

How do you define an array of varchar in a table and how do you manupiluate it? Thanks. ...more >>