Hi all, I am facing an issue on sql server 2000 with sql agent job history. below are the details Box- Windows 200 server Sql server 2000 with...
Hi all, I have an 2 node active/passive cluster on windows 2003 R2 on sqlserver 2000. My storage is MSA500 g2 now i have added 2 more array tothe...
Dear all, I am facing an issue i have a user with dbcreator server role. My server i have set a size and some other setting on model db. Now this...
How can a page split occur on non-clustered index, this will only happen with clustered index as its physically sorted. so why pad_index is allowed...
Dear all, select coalesce(1,0) where 5=2 select isnull(1,0) where 5=2 here how can i get 0, i have requirement like this, am combaining two queries...
Dear all, I saw in the server logs as below (this is a sql server 2000 sp4 clustered environment on windows 2003 with sp2) DBCC TRACEON (3604) DBCC...
Dear all, Problem with Sql Mail OS: Windows 2003 server with service pack 2 SQL: Sql server 2000 with service pack 3 Mail...
dear all, I have started my sql 2000 server on single user mode, > i stoped the server from cmd net stop MSSQLSERVER > then started in single user...
Dear all, How can get difference between two date in sql 2000. say my startdate is '2008-01-01 00:00:43.753' and enddate is'2008-01-01...
Dear all, How we can i access sql 2005 server on a remote location with out connecting to the machine directly? I have a sql 2005 server on remote...
Dear all, We have database on one machine, unfortunately the C: drive of themachine got corrupted and the admin formated the drive, the db was...
Dear all, I have scenarioas below: I have table with more than 25 fields which has around 500k data as ofnow. Every weekend I will get data files...
Dear all, How can we using the STATS in the Backup with MP (am using sql server 200). i want to see the progress of my backup happening and also...
Dear all, I have one job for backing up all databases, till last day it wasworking fine. yesterday i noticed that the status of the job is...
Dear all, We are using sql server 2000 on clustered configuration. for last fews we are getting a log of sql server. SQL Server has encountered 6...
Dear All, How can we find out the last access on a particular database? where can we find this? Thanks in advance to all John
I want to write a store proc with one cursor and the output should be in cursor variable when each time it moves through the cursor the value will...
Dear all, For last few days on my server, sql server is using more than 80% CPU almost all the time, i find out all the thread id, KPID which is...
Dear all, Whilerunning the profiler we could see lots of API Server Cursors being used like(sp_cursoropen, sp_cursorfetch, sp_cursorclose) and this...
Dear all, For last few weeks my production db's CPU usage by Sqlserveris around 80-90%, am in a process to find out what is the reason for this....
Separate names with a comma.
