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 |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2002-03-06 : 05:12:03
|
| Salute..How can I monitor variable values WITHIN a stored procedure??...either from PROFILER or from ADEPT SQL WorkShop?..forget about the SQLDebugger with VB..I hate it!!..Thanks IN Advance ppl..------------------If I am to do it,I will, and NOW .. |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-03-06 : 07:19:49
|
| Sql Profiler should be a good tool to monitor variables and control flow in a Sp and triggers. Alternatively, you can use print command to print the value changes in the sp itself. once you are satisfied with your sp you can do away with print command.HTH-------------------------------------------------------------- |
 |
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-06 : 07:53:44
|
| well thanks BUT,HOW CAN I monitor the VARIABLES VALUES IN PROFILER?------------------If I am to do it,I will, and NOW .. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-03-06 : 08:00:43
|
| It doesn't appear that you can. If you need to set watchpoints and breakpoints and such, you must use the debugger, or put in print statements like Nazim suggested. |
|
|
|
Da_Retina
Posting Yak Master
109 Posts |
Posted - 2002-03-06 : 08:16:05
|
| well thanks both of U..I think that u r both right!I posted a thread about Numega DBPartner for SQL Server..it seems to do the job of SQL Debugger in a better way!..but I cant find an evaluation copy..anyone heard of it?..have a copy??..at least an evaluation copy?thanks------------------If I am to do it,I will, and NOW .. |
|
|
|
|
|
|
Stored Procedure Variables