Wayne,

Thanks for the reply. The "NOT UPDATE" was exactly what I was looking for. I didn't think of trying that. I also didn't realize that if an update doesn't actually...

I thought I might be able to set the value of the param to a new value with the N' prefix but I think that might require some dynamic SQL....

Jack,

Thanks for the reply. I thought it should convert it automatically too because I set the param @Name as an NVARCHAR but it doesn't work that way for me. Not...

Bru,

I had a chance to run your script and it does work. One word of advice is you should run that procedure as soon as you see the offending Process....

Bru,

Interesting article and script. I am not in front of SQL again till monday however I will give this a go as soon as I can. If I get some...

Bru,

Yes you are correct... however there can be many jobs running at any one given time. I could see what jobs are running by using the Job Activity Monitor but...

Bru,

That's where I was looking. Thanks for the reply though.

I actually "fixed" this issue already but I was looking for another way to do it using this logic. Using Rowcount to verify commited changes can be a faulty way...

Yes if the second update fails it will Rollback the first update.

When the trigger that fires on the second update does a rollback (reversing the update) the RowCount for that...

GSquared,

Thanks for the reply. I figured I could achive it with the Count(*) I just didn't know if there was another way.

I actually had another question too...it's is off topic...

Thank you both for the responses... now it's time to go weild my newly armed skills - lookout!

Jack,

Thanks for the reply.

The datatype is datetime are not smalldatetime.

If I remove all references to the 'Active' Column on that table in the Large Read Query then the...

Thanks Jeff for the reply.

These were logical reads. I just figured that a few hundred milliseconds didn't outweigh the 10s of thousands of reads I was reducing the query by....

I missed the @Body = @Body + part....

That does work. Thanks for the help.

Yeah but I want to get messages for multiple invoices in one email.... so I would still have to do a loop or a cursor with your code.