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 |
|
tcarnahan
Starting Member
23 Posts |
 Posted - 2008-10-20 : 17:09:05
|
| I understand from BOL that there is a way to trace execution of stored procedures for the purpose of troubleshooting, but what they describe in BOL is not very clear. Could anyone point me to a good online "tutorial" of how one accesses and uses QA or other tools in EM for debugging stored procedures? Note: I do not have Visual Studio available. Thanks for any assistance you can provide! |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-20 : 18:21:06
|
| do you have SQL Profiler?http://www.developer.com/db/article.php/3482216 |
 |
|
|
tcarnahan
Starting Member
23 Posts |
Posted - 2008-10-21 : 17:21:13
|
| I am a newbie when it comes to some SS2K features. Thanks for the link to the Tutorial on Profiler. I will try it. |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-21 : 18:25:29
|
| Let us know if you need any help with ProfilerYou are heading to the right direction now :) |
|
|
|
tcarnahan
Starting Member
23 Posts |
Posted - 2008-10-23 : 16:52:09
|
| I was looking through the tutorial on Profiler. I can see where you would use it to improve performance, but what do you do if you want to "test" the value of variables during a process?It seems like there was a debugger built into Query Analyzer, but I cannot seem to get it to work. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-24 : 02:33:17
|
| http://www.codeproject.com/KB/database/Debug_SQL_Procedure.aspx |
|
|
|
|
|
|
Tracing execution in SS2K Stored Procedures