Monday, January 2, 2012

How to convert user defined Stored Procedures to System Stored Procedures in sql

How to convert user defined SP to System SP in sql

Converting user user define SP to system SP is very simple method but the question is what is special behavior of System SP .
We can convert system SP in three steps

  1. Create a user define SP(which is going to convert)
  2. Go to master data base
  3. Use sp_MS_marksystemobject SP to convert your SP as System one
  4. The SP name must have prefix 'sp_' which you are going to convert

EX:

USE master
EXEC sp_MS_marksystemobject sp_get_user_info

No comments:

Post a Comment