I would suggest you to go through the article here http://www.myitforum.com/articles/18/view.asp?id=7381 and this thread http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/7bd3d479-df81-456f-8625-c81ec3cecdcc ;

I've got a SQL Server 2000 box [8.0.2039] with a number of databases generally behaving themselves, but one that seems to get thrown into SINGLE_USER mode when the maintenance plan runs. It doesn't happen all the time, it's about a 50/50 chance every week. Is it possible that "Check...

Hi, Thanks for replay, But any column can exceed 255 character length. Now I am getting above mentioned error in 57nth column I have tested this by setting TypeGuessRows to 0 and also 500 but no success. Isn't Microsoft given concrete solution on this issue? Thanx Nishant...

Recien acabo de adquirir un servidor con 4Gb ram con 2 procesadores Xeon Quad E5420 con un disco de 1Tb en dos particiones, sistema operativo W2003 server standart edition y Sql server 2000 standard edition. a esta  base de datos se conectan aprox 200 usuarios a través de un aplicación cliente servidor...

In my SQL SERVER 2000 instance, I found that the JOB that runs the MAINTENANCE PLAN did not have the correct name of the MAINTENANCE PLAN. I changed the MAINTENANCE PLAN name to match the JOB name that was automatically created by the system. Specifically, my JOB name is [DB Backup Job for DB Maintenance...

OS : Windows Server 2003 SP1 Enterprise Edition (Cluster) SQL Version : 2000 SP4 Database size : 75 GB Ran the SQL profiler but did not find any query taking longer time than expected. After that, executed the Performance counters with the following options. \LogicalDisk(G:)\% Disk Time \Current Disk...

Welcome to the forums! [quote] Is there a built in tool to check the database health on SQL 2000? [/quote] AFAIK, no there is no built-in tool available; but you can have SQLCheck from Idera for free http://www.idera.com/Products/SQLcheck/Default.aspx ; although it will not give you all the information...

Refer http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx this will work on 2000 version too.

Hi, see if this link http://support.microsoft.com/kb/891058 helps you

I have to genrate a Store procedures script from SQL sever 2000 when i try to execute these script on Sql Server 2005 it gives the following Error "Msg 15157,Setuser failed because of one of the following reasons: the database principal 'nust' does not exist, its corresponding server principal...