Friday, February 24, 2012

Debugging Stored Procedure

Some days ago i asked here why my debugger in query analyzer never stops at code when i tried to debug a sp. I found the same question to be asked here again and again without any decent answer.
I found out my problem and would like to share it here :

hhtp://support.microsoft.com/?kbid=328151

My sql server was updated with Service Pack 3 but the client wasn't updated.
What i did was to turn on debugging on server for "older" clients with:

exec dbo.sp_sdidebug 'legacy_on'

Hope this will help other ppl too.Thanks for the link!

No comments:

Post a Comment