SqlServer 2000 - Why won''t my debugger work on all servers?

  • here the deal.  under

    * my local DB I can right click a stored procedure and click execute it will load and then allow me to step thru it with the yellow arrow

    * when I connect to another server and right click on a stored procedure and click execute it will say "wait for user Input" and automatically start running and finish.  I never get the yellow arrow.  When it finishes, I then try and set  breakpoints; it will accept breakpoints and when I run it the sucker just run and never stops at the breakpoint. 

    The Stored Procedure is the same on both pcs

    Any suggestion or idea would be GREATLY appreciated

     

  • I'm afraid, if I recall from Rob Viera's book..u got to have both sql and domain authentication level [simply - mixed authentication] set to run the debugger properly...

    I'm sorry if this isnt the case


    Get busy living ....or get busy dying....

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply