Post reply

EXECUTE permission denied on object sp_sdidebug

  • February 24, 2004 at 3:14 am

    #161634

    I am trying to debug an SP on a remote server, and am getting the below error.

    Server: Msg 229, Level 14, State 5, Procedure sp_sdidebug, Line 1

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

    I have the registration properties for the server set as follows:

    Login: sa

    Show system databases and system objects: True

    However I cannot see the 'sp_sdidebug' object in the master DB to set the EXECUTE permissions.

    Can someone please point me in the right direction?

    Thanks in advance,

    Carl.

     

  • February 24, 2004 at 3:20 am

    #495266

    Forget that - I am was having a dizzy moment. I have found it, but am now getting the following error whilst trying to debug:

    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' ITransactionLocal::StartTransaction returned 0x8004d013:  ISOLEVEL=4096].

    Any ideas what this means?

     

  • February 24, 2004 at 3:24 am

    #495267

    I am having a really bad day - forget any of this, I have solved it.

    If there are any moderators viewing this, feel free to delete this thread altogether!!!!

    Thank you.

  • May 27, 2004 at 10:51 am

    #508064

    Having the same problem, would have been nice if you posted the solution .... anyone know what causes this:

     

    EXECUTE permission denied on object 'sp_sdidebug', database 'master', owner 'dbo'."

  • May 27, 2004 at 11:31 am

    #508068

    Are you logging in using a sysad level account?

    This is an extended stored proc in master, and you have to be a sysad to execute.


    Shamless self promotion - read my blog http://sirsql.net

  • January 24, 2005 at 1:59 pm

    #538824

    Sorry for bumping an old thread, but I am having a similar issue, but my case is that I am trying to run an update query using OpenQuery.

    Here's my error message:

    Could not start a transaction for OLE DB provider 'MSDASQL'.

    [OLE/DB provider returned message: Neither the isolation level nor a strengthening of it is supported.]

    OLE DB error trace [OLE/DB Provider 'MSDASQL' ITransactionLocal::StartTransaction returned 0x8004d008: ISOLEVEL=4096].

    Any help or pointers in some direction would be really appreciated.

    Thanks.

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

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