Quote:
Originally Posted by lynxrufus03
hi everyone...
i am having problem debugging my sql scripts. if i run the application, the stored procedure fails, but if i run the stored procedure in SQL Analyzer, it is successful... i used the SQL profiler to trace the sequence of events in the stored procedure and triggers, however, i cannot see the data of the declared variables.. my question is, is there a way to know or see the contents of the variables in SQL Profiler?
any help would be appreciated...
thanks in advance....
To display the value of varaible on the messages screen do:
PRINT (@myVar)
