Friday, March 30, 2012

Print in Trigger Statements.....

SQL Server books online has 'print' statements in the trigger examples.
Where exactly the print will happen? How to get benefit of this while
debugging?
Thanks,
Jessy
You can make execution visible in the query analyzer, can print out some
information about filled variables, rowcounts, status of transactions etc.
While debugging you can also watch the value of the variable with the
properties pane.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Jessy Martin" <Jessy_Smith79@.hotmail.com> schrieb im Newsbeitrag
news:%23MweP25ZFHA.616@.TK2MSFTNGP12.phx.gbl...
> SQL Server books online has 'print' statements in the trigger examples.
> Where exactly the print will happen? How to get benefit of this while
> debugging?
> Thanks,
> Jessy
>

No comments:

Post a Comment