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...

By the way, I realized that it looks like I'm recommending sp_OA procs. I'm not. They're slow and memory pigs, but an option. Just wanted to clarify that.

Lumigent Entegra.

It's related to Log Explorer, using some of the same technology. It also tracks object changes in the system so you can see if unknown users are changing tables...