469,927 Members | 1,777 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,927 developers. It's quick & easy.

how to see the data of variables in SQL Profiler

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....
Aug 1 '07 #1
1 2941
DonlonP
25
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)
Aug 1 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Zap | last post: by
32 posts views Thread by Neil Ginsberg | last post: by
2 posts views Thread by ivanlkc | last post: by
8 posts views Thread by Bryan | last post: by
reply views Thread by David Linsin | last post: by
3 posts views Thread by Sam Samson | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.