locked
How to change User SP to Sys SP RRS feed

  • Question

  • Hi Everyone,

    I have created one store procedure under Master DB, but i want to reset it as sys store procedure.

    Is this possible in SQL Server 2008 R2  Environment ??

    Pls Help..

    Friday, September 19, 2014 10:14 AM

Answers

  • Hello,

    What should that be good for?

    You can by using the System SP sys.sp_MS_marksystemobject, but it's undocumented + unsupported and it's not possible to revert it.

    If you need a stored procedure available in all databases then Name your SP with "sp_..." in master database, SQL Server will lookup first there.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, September 19, 2014 10:40 AM

All replies

  • Hello,

    What should that be good for?

    You can by using the System SP sys.sp_MS_marksystemobject, but it's undocumented + unsupported and it's not possible to revert it.

    If you need a stored procedure available in all databases then Name your SP with "sp_..." in master database, SQL Server will lookup first there.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, September 19, 2014 10:40 AM
  • Thanks Oalf..

    You are the BEST.

    Monday, September 22, 2014 1:11 PM