Post reply

Phantom system stored procedures

  • January 16, 2004 at 3:15 pm

    #84355

    I have a bunch of dt_%  system stored procedures in my database but can't delete them.  They are all related to Visual Studio, looks like they got copied from a dev database to production.

    Any ideas how I can get rid of them?

    Thanks,

    Jim.

  • January 16, 2004 at 4:14 pm

    #490569

    why do you care? Extra procs have no impact on the system.

  • January 19, 2004 at 6:59 am

    #490653

    It looks messy and they shouldn't be there. 

  • January 19, 2004 at 7:45 am

    #490663

    just execute  

    drop procedure PRocName from the db where they belong.

     

    please post the errors here if any.

  • January 19, 2004 at 9:15 am

    #490693

    Interesting, I can remove them from QA but not from EM, thanks for your help...

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

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