Posted by Hugo Kornelis on 01/26/06 22:52

On Thu, 26 Jan 2006 01:19:30 -0500, serge wrote:

(snip)
>>You could add a SELECT to the trigger code, then test your code from
>>Query Analyzer. The values in the inserted and deleted pseudo-table
>>would go to the Query Analyzer results pane.
>
>Too bad ADD WATCH isn't available.
>Anyone knows if SQL 2005 allows to add watches and monitor the
>contents of the inserted and deleted when debugging triggers?

Hi Serge,

I don't know. I haven't seen the debugging capabilities in SQL 2005 yet.

In SQL 2000, the debugger was integral part of the product. But that has
been removed from SQL 2005 - you can now only debug triggers and stored
procedures if you also have Visual Studio installed.

http://lab.msdn.microsoft.com/ProductFeedback/viewfeedback.aspx?feedbackid=cb5678d4-2dab-4375-a806-f50123f6d235

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: select cast help needed
• Prev in forum: Re: Difficult SQL Statment
• Thread view: Re: Can i debug/watch on the trigger's INSERTED and DELETED records/values?

[Reply to this message]