October 22, 2003 at 2:45 am
How to Debugg a StoredProcedure in Query Analyzer?
October 22, 2003 at 4:59 am
Hi,
In Query Analyzer show the Object Browser go the the stored procedures and right click on the proc you wan't to debug. Debug is the last option in the list.
Cheers
Andy.
October 23, 2003 at 9:40 am
The debugger interface is required on the client.
RandyHelpdesk: Perhaps Im not the only one that does not know what you are doing. 😉
October 23, 2003 at 10:21 am
I started using this recently and discovered a bug/feature. I have a stored proc which takes a date value to run. I can go to QA and type the SP name and '10/12/2003' and it runs. If I try debug and put the same value in the debug window it errors out
October 24, 2003 at 1:26 pm
This "quirk" used to bother me too, until I discovered that the only format the debugger will accept the date parameters is "yyyy-mm-dd"
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply