There could be many different issues. This is one of the possible reasons.

Connection closed by remote host.

which shows your connections are getting disconnected. High probability that its due to network...

I would do it on both servers.

Go to property of network connection.

Click -> Configure

Go to Power Management tab

There you will find check box for "Allow the computer to turn off...

Check the network card properties and see if "Allow the computer to turn off this device to save power." is checked or not. If it is checked, that could be...

I am trying to get both resultsets of stored procedure and save it in tables. Then parse through it.

I dont want to get code out of procedure and run the...

fapel did you get any solution on that?

What kind of errors are you getting? Is SQL 2k5 installation completing successfully or is it failing before that? I am sure you are but just out of curiosity are...

based on the naming conventions. You need to name the script so if you order scripts by name it appears in the same order as you want to execute. We...

We are using it for database builds for several projects and it works great.

Did you try Visual Build? We are using visual build and Visual source safe, in visual build you can create build package for full build as well as incremental builds....

You can use sqlmaint utility too. Look in BOL for SQLMaint utility.

Check "DBCC DBREINDEX(Table_Name)" in BOL

Microsoft supports SQL 2000 with SP3 or above on Windows 2003. We have around 20 SQL Server 2000 instances on Windows 2003 and we dont have any problems.

Hi,

I had same problem about orphaned users, i just ran update query on the sysusers table for all the databases for orphaned users to update their sid to correct one,...

You can run following script against master database which will list all databases with their recovery mode on the server.

################################################

Create Table #temp1 (databasename varchar(200), Recoverymode varchar(200))

Declare dbname CURSOR

FOR

select name from sysdatabases

Declare...

It seems your sysdatabases table in master database doesn't have entry for tempdb. Is SQL Server Running? I had same errors when one of my collegue detached tempdb. If SQL Server...