> a year later, ha... I ran across this thread in a search and realized I never came back and posted the version I've been using since shortly after my...

Such complexity to handle something built-in and simple to configure? I concur... use alerts instead!

USE [msdb]

GO

--create "Operator" with customer's email

EXEC msdb.dbo.sp_add_operator @name=N'AppSupport',

@enabled=1,

@email_address=N'customer@emailthem.com',

@category_name=N'[Uncategorized]'

GO

--create deadlock alert

EXEC msdb.dbo.sp_add_alert @name=N'DeadLocks',

@message_id=0,...

SELECT ID

FROM table1

EXCEPT

SELECT ID

FROM table2

Runs MUCH faster. Thanks.

Guest Columnist Ken Simmons suggested I look at EXCEPT. Sounds just like a left join. I'll post back and let readers know it it improved my query exec time.

From MSDN:...

I added stored proc drop and create statements, meaning you run the following to create a proc, then just exec sp_who2DMV...

USE [master]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id...