Debug Sp
-
I am trying to dubug some of stored procedure which is located in my local server and as well as database which is located in network. I followed all steps which found in Sql Server 2000 help. But the moment i start debug, the debugger is not allowing me to step into/throu. Why this ? What will be the issue. Sreejith Nair [ My Articles ]
-
I am trying to dubug some of stored procedure which is located in my local server and as well as database which is located in network. I followed all steps which found in Sql Server 2000 help. But the moment i start debug, the debugger is not allowing me to step into/throu. Why this ? What will be the issue. Sreejith Nair [ My Articles ]
You can copy the body of your sp to Query Analyzer and debug it there. Replacing input variables foe DECLARES and use SET @Variable to set intial conditions.
-
You can copy the body of your sp to Query Analyzer and debug it there. Replacing input variables foe DECLARES and use SET @Variable to set intial conditions.
That is what i am doing. But the moment i try to start debug, the Queary analyzer won't allow me to do setu throu/down. It completes the Sp execution automatically. Sreejith Nair [ My Articles ]