I remeber I can use analyzer to debug sql in 2000, and it seems it does not have the analyzer in sql 2008 any more. Here is what I do:
1. select the SP, then script SP to->execute to->new window.
2. click debug.
then step into the SP line by line.
Is this the correct way to do it? one problem is: I will have to script the input into the SP directly. Is it possible to let sql pop the window and ask for input like analyzer does?
View Complete Post