With SQL 2008 to be released next year, it's likely those exams will be retired. However there are lots of SQL 2000 instances still running, so I'm not sure your...

The login needs to have the connect right. There is no execute stored procedure needed to create the connection. It just needs the ability to connect, a user mapping in...

I'd use the scripting facility and script out everything related to security. Then search for the old domain and snag those items out into another file.

You need to better define what you are looking for. This is too broad a question to be answered.

You need to better define what you are looking for. This is too broad a question to be answered.

Not sure about the others, but SQL Server 2000 allows you to specify select, insert, update, delete rights separately to individuals or groups (roles) at the table and column levels.

I agree with the info above. I've never seen this as a security risk.

Gail's given great advice. I'd follow what she's listed.

Thanks for the update and glad it's working.

Does tempdb autogrow?

Is there disk space?

Have you rebooted?

First, watch your posting. This was in the 2005 forums (moved now), and likely will get skipped if people are reading for that version

Try this: http://support.microsoft.com/kb/281574

Check and see if the user has been explicitly denied permission, either to their login or a group.

It's not really any more log space to run backups every 5 minutes. You might want to change that.

No idea, but it makes some sense. If you restore master, it's not meant to recover on another server. If you recover somewhere else, it's expected (I'm guessing), you will...

LOL, that's funny. A good reason to use "gender" in your DDL 🙂