Posted by Erland Sommarskog on 01/26/06 00:27

serge (sergea@nospam.ehmail.com) writes:
> When i debug a trigger is it possible to add a WATCH
> on the INSERTED or DELETED?
>
> I think not, at least I couldn't figure out a way to do so.
> Does someone have a suggestion on how I can see the values?
>
> I did try to do something like
>
> INSERT INTO TABLE1(NAME)
> SELECT NAME FROM INSERTED
>
> but this didn't work. When the trigger completed and I
> went to see the TABLE1, there were no records in it.

In additions to Hugo's suggestions, keep in mind that if the trigger
fails, then the statement will be rolled back, and that includs the
data insertedvinto Table1


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Question on SQL Server 2000 - 2005
• Prev in forum: Re: Scalability questions for extended stored procedure
• Thread view: Re: Can i debug/watch on the trigger's INSERTED and DELETED records/values?

[Reply to this message]