Post reply

How to drop the extended stored procedure

  • June 13, 2011 at 5:22 am

    #237724

    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...:-)

  • June 13, 2011 at 5:30 am

    #1337677

    Why are you trying to drop one of the system procs? I'd leave that alone.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 13, 2011 at 5:39 am

    #1337682

    🙂

  • June 13, 2011 at 6:02 am

    #1337693

    that stored proc is used inside other system procedures...if you were to drop it, i guarantee you will, at a minimum, break replication, the SQL Agent, scheduled jobs,let alone lots of other system functions.

    prove it to yourself: this was jsut the first place i looked, as I KNOW i'd seen this called in a DML trace i run occasionally:

    select object_name(object_id),*

    from sys.all_sql_modules

    where definition like '%xp_reg%'

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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