Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
influent
Constraint Violating Yak Guru
367 Posts |
 Posted - 2006-03-27 : 15:37:08
|
| Sorry if this has been asked a million times, my search was unsuccesful. Is there any way in SQL Profiler to have it show the value of variables? For example, if I'm running a script in QA, and as part of the script I say PRINT @VAR (crude example), I'd like to see the value of @VAR in Profiler... is that possible? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-27 : 15:43:03
|
| No. Do you just want to debug? If so, you can do that in Query Analyzer.Tara Kizeraka tduggan |
 |
|
|
influent
Constraint Violating Yak Guru
367 Posts |
Posted - 2006-03-27 : 16:11:57
|
| Hey cool, I never used Debug in QA till now, seems pretty nice. Still seems weird that Profiler doesn't do that, but oh well. Thanks Tara. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-03-27 : 16:18:12
|
| Profiler is to trace statements, not data. To trace data, you would need to audit your data via triggers, code or use a tool like Log Explorer.Tara Kizeraka tduggan |
|
|
|
|
|
|
variables in Profiler