Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Germany
    Posts
    20

    Unanswered: 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.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Thanks for the link!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •