How to drop the extended procedures

  • HI All

    while i am droping the extended stored procedure....i got following error

    "Cannot drop the procedure 'xp_regdeletekey', because it does not exist or you do not have permission."

    how can i resolve it.

    its very urgent . any body help on this...

  • kollisudheer27 (6/13/2011)


    while i am droping the extended stored procedure....i got following error

    "Cannot drop the procedure 'xp_regdeletekey', because it does not exist or you do not have permission."

    how can i resolve it.

    its very urgent . any body help on this...

    :w00t: why would you want to drop an xp_?

    If for some obscure reason this is really needed, ask somebody with the right privileges to do it.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • Please don't cross post. It just wastes people's time and fragments replies

    No replies to this thread please. Direct replies to http://www.sqlservercentral.com/Forums/Topic1124167-1550-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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