Debugger not work propertly

  • When I try to debug stored procedure in SQL Server 2000 Query Analyzer I got error message

    SP debugging may not work propertly if you log as 'Local system account' while SQL Server is configured to run as service. You can open Event Viwer to see details ...

    After this msgbox I press F5 to start and got error

    Server: Msg 508, Level 16, State 1, Procedure sp_sdidebug, Line 1

    [Microsoft][ODBC SQL Server Driver][SQL Server]Unable to connect to debugger on COMPAQ-NX6325\PRERADA_MESA (Error = 0x800401f3). Ensure that client-side components, such as SQLLE.DLL, are installed and registered on COMPAQ-NX6325. Debugging disabled for connection 55.

    What I have to do to work with debuger

  • execute this script on query analyzer and see if it works.

    "exec sp_sdidebug 'legacy_on'"

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

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