Post reply

debug a remote instance

  • March 17, 2006 at 9:15 am

    #112321

    Hello!

    Is there any way I can debug a procedure that is in a remote instance?

    I can do that in local, but never was successfull against another machine.

    Servidor: mensaje 229, nivel 14, estado 5, procedimiento sp_sdidebug, línea 1

    [Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'.

    Thank you!

  • March 17, 2006 at 11:28 am

    #627424

    As long as you have the rights to do it in a remote server, you should be OK. This server should only be a Development Server though!!

     

    In order to debug, you need EXECUTE permission on sp_sdidebug. Also, if you have SQL Server 2000 SP3 installed, you need to execute sp_sdidebug with the "legacy_on" parameter (which must be done everytime you restart SQL Server).

     

    Cheers,

     


    * Noel

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

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