I'd agree about using roles. This is exactly why you do it. Take a few minutes and move the permissions to a role and then ad your new user.

You can use this to try and shrink the log

http://www.sqlservercentral.com/scripts/contributions/26.asp

You can move these selects to the FROM clause.

select a, b, c, d

from main, (select c, d, from mytable) b

It seems the IE pastes them in as highlights, but Firefox does not. I'll see if we can do something in the forum code for this.

Yes, sigs need to be manually done, but this is a cut and paste:

http://www.sqlservercentral.com/columnists/sjones/

Haven't seen this. Course, I haven't restored a v7 db in quite some time.

Are you restoring through the GUI or with T-sQL? I might try TSQL to see if any...

Wow, offhand, I'm not sure what to do here. Since some items are not in ", I'm not sure the above will work.

I think I'd write some VBScript or small...

Or "fix" the existing user in the prod database with the test login by using SP_CHANGE_USERS_LOGIN.

You can also look at SET STATISTICS IO ON and see the reads and writes that are required.

What about a delay between the start of execution? Or call 1 proc and have it fire the other 2?

I think Profiler is the best way if you suspect a problem. If you are trying to troubleshoot, get the user to open another connection and see what comes through....

This is an incredibly broad question. I think you should read the articles on this site as well as keep an eye on the active posts in this forum to...

They can be, depending on how it's posted.

Apologies for the mistake. And yes, these things get through QA sometimes. I didn't catch the different table names because I cut and paste the query into QA, create the...

There isn't a good way. You can run sp_who2 on each system every 5 minutes and get a high water mark for connections. That would tell you the per server...