Post reply

Update system stored procedures

  • November 14, 2006 at 11:36 am

    #117615

    How can we update a system stored procedures.I know we can configure allow update  1 to update system tables.How about to update system stored procedures?

     

    Thanks for your help.

     

    SR

    Thanks,
    SR

  • November 14, 2006 at 11:52 am

    #671735

    Copy the system procedure and create under a new name, make the modifications to the copy and use the copy in your code.  That won't break the system and Microsoft will continue to guarantee its products.  Also the modifications won't be lost in a service pack upgrade.

  • November 15, 2006 at 2:28 am

    #671878

    Totally agree with this approach. You do not want to alter the original system sprocs. This would lead to maintainability issues for subsequent DBAs when these procedures no longer behave as expected.

  • November 16, 2006 at 4:11 am

    #672216

    Yep totally agree, and I tend to use the sp__DBA prefix so I can easily identify the ones I created and in the hope Microsoft will not use the same name in a future release

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

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