Someone pointed it out; we don't know what the issues are. It's like us designing applications and users not realizing what the issues are until they see the final product....

I thought you had an interesting idea and it's worth considering for other people. I'm not sure how performance has changed. That would be an interesting follow-up.

Actually it would be...

You should be able to limit users from deleting entire tables. If you are restoring them, likely it's not part of their job.

You can download Log Rescue from Red Gate,...

How are you getting the new name? It it just the letter plus the row number? You need a tally type table to do this in 2000.

You can run fn_my_permissions once connected to see what permissions she has.

http://msdn.microsoft.com/en-us/library/ms176097.aspx

If you are getting the connection timeout, likely she is having network issues. Could be communications or firewall. How...

Be sure you know where and how to look for answers as well. You might get stumped, but it will help if you know how to find answers.

insert select works well.

The IN function expands to a series of ORs for each value. Performance depends on how many you have and how you are indexed, as well as the data distribution.

you...

While I'm sure you'd enjoy going home, you should change the password. Finding a DBA or even moving to another workstation is fairly inefficient.

First backup to separate drives than you store data on, or script out a copy immediately.

Depending on size, I'd run a full every night and differentials in the middle to...

Did you lose a disk or move things around? It looks like either you have a bad disk, or it moved. Is the error log back there?

Also, check the...

Interesting subjects. And thanks for the laughs. Glad I didn't forward that beer one on to Tony.

My Mom gets all kinds of stuff from friends and sends it on. I'm...

I think all of us have done some of this with root cause analysis or backtracking through logs to find out what happened. Data has an interesting aspect in that...

Are you connecting via named pipes? Check your client config.

You want to have a specific port set for each instance and then use that in your registration on the client....

It sounds like it just flaked out. AFAIK, the restore with standby should not take much longer than a restore with norecovery.

Perhaps you have transactions open in the secondary database...