August 31, 2005 at 4:24 am
Hi,
Can any one help me how to debug a stored procedure, i went to query analyzer and i right clikced on STORED PROCEDure i selected debug option also but it is not giving any error when i kept he break poing on any line it is not stopping stored procedure is executing.
August 31, 2005 at 5:37 am
Try executing this:
sp_sdidebug 'legacy_on'
in Query Analizer in the same database you are debugging..
August 31, 2005 at 6:05 am
Aswani - do you first get a warning box saying that "..Debugging may not work properly if you log on as 'Local System Account'..." ?!?!
If you do, then you have to use an actual user account...(EM - properties - security)
**ASCII stupid question, get a stupid ANSI !!!**
August 31, 2005 at 6:09 am
iam doing from sql query analyzer i didnt get any warning message , i logged as a administrator...in my system i have only client,,,,
server is in other place.
August 31, 2005 at 6:15 am
ok - then have you tried Tyson's suggestion ?!?!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply