We use Redgate SQL Compare.

You should know that there are several other tools out there in addition to the ones that others have already mentioned. Embarcadero has a pretty good...

Sounds like a really good script. I'll check it out when it becomes available.

One point, blocking locks and deadlocks are two different things. Deadlocks are caused by two processes...

Great answer. I should have thought to add all of that but didn't. Thanks for help.

As long as you know that you may have some number of transactions that cross over... No, it's not a big deal at all.

Set the the traceflags -T1204 and -T3605. This will write the basic deadlock info out to the SQL Server error log. Profiler will still be more useful in tracking down...

The biggest issue with going to Windows Authentication is the lack of support for this from third party applications. Almost every single one of them that I've installed since the...

Manual tests are probably run under your user context where as the automated schedules are running under the security context of the SQL Server instance. You need to verify that...

If it has to be part of the process, why not simply insert into both from the initial proc?

If you need to make it an async process, something along...

How do you mean "it won't let you copy the script?" I ask because, that's how I've migrated SQL Agent jobs in the past. Export them out to a script...

Create a compound index that is FromDate, ThruDate and then the null values on the ThruDate won't be a problem. Others will argue to set the ThruDate to the max...

I'd second this one. Even with a three minute timeout we get some pretty hefty loads running on the machine. And the fact of the matter is, no one should...

You can't change it on the fly once its running. What we do is set a stop point when we start it so that it will run for 24 hours...

We stop & start ours daily (not because we have so little data, but because we have so much). If you just set the file name using the date, you...

Those look right.

You may not get a shrinked file the first time you run that if the transactions are still operating out at the end of the file. The lazy...

Just wait for the trace to roll over and you can get the data.

We created a new file name each time we started it, using the date of the start...