Cool Article.

IF EXISTS(

SELECT *

FROM DELETED D INNER JOIN INSERTED I

ON D.PS_ID = I.PS_ID

WHERE D.Ps_PreBase  <>  I.Ps_PreBase

OR    D.Ps_Costo  <>  I.Ps_Costo

OR    D.Ps_PreVta  <>  I.Ps_PreVta

OR    D.Ps_PreSug  <>  I.Ps_PreSug

)

BEGIN

BEGIN TRANSACTION

 ...

how do I apply this same solution to commit every 1000 inserts??

Hi Chris, no you can still use DBO_ONLY in 2000. I forgot to reply to my own post when I figured out that I forgot to include With NORECOVERY on...

I have spent all morning trying to fix the same problem. It is strange, when I send  a test email from EM it works fine the email gets sent and...