Post reply

sp_sdidebug query

  • July 12, 2006 at 5:08 am

    #191265

    After a few performance issues with my dotnet application I ran SQL Profiler and found that before each stored proceedure I called the following 3 calls were made (identical each time) -
     
    exec sp_reset_connection
    exec sp_sdidebug @Parameter1 = 'on', @Parameter2 = 'MSSDI98
    exec sp_sdidebug @Parameter1 = 'context', @Parameter2 = 2116, @Parameter3 = 528

    I understand the sp_reset_connection is called when I reuse a connection from my connection pool and that sp_sdidebug is used for debugging using visual studio but how do I switch it off? I have tried sp_sdidebug 'off' and sp_sdidebug 'legacy_off' but it makes no difference.

    Anybody shed a bit more light on this as I'm not a dba.

    Many thanks.

  • July 15, 2006 at 3:28 pm

    #649418

    Right click on the project go to "Properties" and then find "Configuration Properties" tab, under "Debugging" section unchech "SQL Server Debugging".

    Hope this helps.

    Cheers.

  • July 17, 2006 at 1:52 am

    #649467

    Thanks. Worked a treat.

  • July 17, 2006 at 1:56 am

    #649468

    You're welcome

  • August 4, 2006 at 7:17 am

    #653312

    Hi,

    in my case there is no option available for SQL debugging as u suggested what should i do to stop firing "sp_sdidebug"

  • August 4, 2006 at 10:31 am

    #653382

    what is your development environment?

Viewing 6 posts - 1 through 5 (of 5 total)

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