You also have to switch on trace flag 3605, in order to get the deadlock information sent to the SQL Server error log.

I generally use the following statement;

DBCC TRACEON (1204,...

Not sure if this is helpful, but could you make use of the fact that count(*) includes nulls, whereas count(field1) will exclude them, and then exclude groups where the result...

Sorry, I defer to the previous 2 posters, pipped at the post!

Just MIGHT be possible, but could get very messy.

A simpler way would be to write a little VB applet and add a reference to the SQLDMO object library to do...

Not sure whether this has been verified, but are both SQL Servers at the same service pack level?

The query optimizer has had minor tweaks between SPs, especially where parallel queries...

quote:

---

Thanks Jpipes, it worked great!

---

BTW, this is exactly what I do as well, but...