Post reply

Alter system stored procedure

  • May 8, 2003 at 2:41 am

    #58630

    When altering a system stored procedure it become a user stored procedure.

    What can I do to change it back to type System?

  • May 8, 2003 at 3:36 am

    #456500

    Look at sp_MS_marksystemobject in the master DB. It can mark it system again but be carefull you might impact server stability doing this and potentially a later HotFix or SP will overwrite what you have done.

  • May 8, 2003 at 2:46 pm

    #456592

    didn't know you could change sys procs !!!!

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

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