I'm guilty of using this for pretty much the same reason. If I have a sp that I know will be ran frequently, i go modify my template code...

Does it show up more accurately in a trace, capturing CPU Duration and Disk IO? Perhaps filter by the SPID once you connect?

It's not because you are using a table function to get your results from? I think the statistics are missing from within that function - what it's timing is...

Your factory cars and your custom cars could both use model references - you just have to create a model/manufacturer

for the custom cars also. Something like Manufacturers->Models->Cars, then Purchases->Deliveries->Sales }>...

I assume that the exact same script/sp gives the intermittent result you showed above? If so could you post it? This one is really odd now that I...

Sorry should have read closer. You ran it into a temp table. Above wouldn't apply.

Perhaps the bulk of the 3 minutes occured after the query had processed the data, but it was still sending the data to the client over the network, and QA...

As for editing the system tables, the only time I have ever done that is when 'copying' diagrams, because there was no other way to do it. At least...

Maybe this would work:

sp_grantlogin [@loginame =] 'login'

sp_grantlogin

sp_revokelogin

Note that the SQL security account procedures and the NT security account procedures differ.

If you got a snapshot of all of the logins/role membership/permissions...

Still don't see how any of your old SIDs are valid.

This will be an interesting thread for me since we plan to migrate to AD soon. If it is...

Another thing that may be allowing them in, other than what I mentioned before, would be if they had SQL logins created for them (ones that bypass NT/AD security) and...

I'll give this a shot but I'm not real confident in what I thought was correct, since you are saying that even a few of them are still working. ...

Nothing pre-made that I know of.

If you are only wanting to deal with field changes you can write scripts that will look for table differences fairly easily. Personally I...

http://www.adeptsql.com - look for the SQL Diff tool. You can demo it.

Basically you select a two DBs and it compares everything but the data- code in sps,...

For Development -> Production server deployment I use SQLDiff. Quite handy for what I use it for. Sort of pointless if you don't have a 'model' db to...