Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2003
    Posts
    1

    Question Unanswered: T-SQL Debugger Won't Work

    I'm am trying to use the debugger in Query Analyser and am have trouble.

    I start debugger, enter my one parameter, click execute and debugger begins running the procedure.

    I must stop debug to add breakpoints then begin the debug again and the program runs as if there were no breakpoints.

    Is there some secret to debugger?

  2. #2
    Join Date
    Nov 2003
    Posts
    2

    Re: T-SQL Debugger Won't Work

    Was this ever resolved because Im having the same problem, the debugger just executes without stopping so I cant set a breakpoint

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    SQL 2k?

    You need to have an unnammed default instance on the box. If not it won't stop.

    Also you need to connect with something other than LocalSystem account. You need to connect as a user *

    * Just happened to be reading that in Henderson's book at the moment

    http://www.amazon.com/exec/obidos/AS...500230-3093557
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Did never like the Sql Debugger. Have you ever seriously tried to use it .. Brett ??
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  5. #5
    Join Date
    Nov 2003
    Posts
    2

    all fixed now

    I just found the fix - it was to run :

    exec dbo.sp_sdidebug 'legacy_on'

  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by Enigma
    Did never like the Sql Debugger. Have you ever seriously tried to use it .. Brett ??
    Never had the need...

    Although, now with this call center disaster project dumped on me...I might...

    Looking to Profiler first though...

    Got any good templates?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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