You should be able to use the CREATE DATABASE...FOR ATTACH syntax (see BOL). Or, you could do a backup/restore.

I wake up in the morning thinking the same thing as Jeff; but generally I spend the day replacing the curse words in my head with much nicer (though no...

For me the soft skills came from being a customer service professional (conference call operator), and working my way all the way up to Assistant Director of the department. After...

Since you didn't mention it in the original post...did you physically move the actual files to the new directory?

Thanks Renato. We've rebooted these servers multiple times, to no avail. THanks Everyone; after talking to MS, looks like we may be trying a new domain account, to see if...

Doesn't look like my last post went through...Derrick, you might have something there. I'll be checking with our Exchange Admin on that. Although, our Dev servers use the same config...

Derrick,

Thanks for the replies. To answer:

I think the DLL theory is probably sound, if it weren't happening on more than one server (I forgot to include that in the original...

That's becuase it's primarily used by SQL Server itself, in the administration of MSX/TSX jobs. I don't recall any specific links that'll help describe it better; I spent a lot...

We're using SQLLiteSPeed 3.0 in our shop, and we've fallen in love with it in a matter of days. We've compressed our 198 GB database backups to 26.9 GB, and...

In our environment, which is now entirely SQL 2K SP3, we were still able to use the TargetServerRole, with very few tweaks to it's permissions. Our objective was only to...

You have to move model first, then the msdb from the same server. Check KB article 224071, it has the instructions for 7.0/2K.

Thanks Antares. I appreciate the notes. Hopefully, we'll get the SAN solution we are trying tp pitch.

In BOL, there is an entry concerning "Security Account Delegation". Search for it and you will find that this may be a fix you need to implement. Basically, it concerns...

Thanks; we've been seriously considering that "motivational technique".

I know that the scenario described is a standard one; I just want to find out if there's any blazing potholes I...