Just curious, why would you want to script out creating the databases on your system if you do not want any of the tables, keys, indexes, etc that the database...

Does the error log or Windows logs show anything?

Is this error on a cluster? I found someone who seems to have had a similar error which was fixed by setting up the virtual network names.

http://www.eggheadcafe.com/software/aspnet/30282373/sql-cluster.aspx

Curious, is it just Query Analyzer that you are having problems connecting with? Can you connect to fine using the hostname with Enterprise Manager or osql?

Did your system ever have a different hostname? I wonder if that could cause the issue? What protocols are enabled for connection to the instance?

Is this database on the local machine or a remote machine?

What permissions/roles does the account that you are trying to connect have in SQL? If builtin\Administrators has not been taken...

How many cores does the server have? I would imagine that is going to limit how many concurrent threads can run at once.

bhoward 86472 (1/8/2010)

--------------------------------------------------------------------------------

Getting your nuts busted a bit cause many of us have been there...not me of course

Doesn't Red-Gate have some tools for recovery via the log file? I...

Could it be that it is not a network issue but a timeout issue, so SQL reports an error even though the SP is still running?

You can run a continuous...

Um, just to clarify, if your server only has 3GB of memory, setting the /PAE switch in the boot.ini file and setting AWE in SQL will do nothing for you....

I agree with running the DTS job during off-peak hours so that user impact is at its least. Also, there is the added benefit that there are not as many...

I totally agree with Ellis on this. Get AWE off of that instance and ensure your min and max memory settings are what are going to be adequate for the...

If you do not have over more than 4GB of memory in the machine, then enabling AWE will do nothing for you. It is meant to take advantage of memory...

It is hard to say since none of us know the entire situation involved, but first...

I think you have the latest version, although there have been some hotfixes that have come out since 2.8 sp1 you might want to check to make sure you...