They shouldn't be sa. Since I assume you will refresh QA fairly often, give the developers db_owner in the dev database, and when you refresh QA, have a script that...

There is no integration with EM. The only way I've been able to do this is remove rights from the dev server and designate someone to make changes. This way...

Not sure what you mean. What's "BIG" and "One Day"? Can you provide some actual dates with examples? I suspect you want to use a CASE statement, just not sure...

I usually grab the sp completed, and stmt ending events, check the duration and do a count of the instances and go from there. I think the standard template that...

glad I could help. When you see something strange like this with an index, constriant, etc. Often it's bound to another object.

I believe developer edition is licensed differently. There isn't a per processor or client AFAIK. You cannot use this for production. You'd need to uninstall, then reinstall the server version...

seemed to drop it fine when I did it on my local server. I expect that somehow the constraint got linked to a different table. Can you check in sysconstraints...

If there is an error in the first item, a rollback will occur and there is no transaction. You don't want to do the save if the first rollback occurred.

That's the only way I know and it only works for indexes or tables that have a clustered indexes. not sure how to determine for Stored procedures, heaps, views, etc.

I used a low tech approach.

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

SQL Server will move through the log files and log to one, then the other, using virtual log files within each physical file. You need to add some transactions, truncate...

My process isn't without flaws and I'm sure I can learn a few things from you guys. It worked well and 90% of the time, so I just dealt with...

Not that I know of, but I plan on doing some sp2 testing on a VM over the next few weeks. Will let you know how it goes.

How are you doing the insert? You cannot turn off logging, but you can BCP in with different logging or commit after xx rows to minimize the log growth.

You must be rebuilding indexes or doing something I don't do. None of mine fail when a conneciton is open. Some of the options require an exclusive connection in the...