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
- Create a user define SP(which is going to convert)
- Go to master data base
- Use sp_MS_marksystemobject SP to convert your SP as System one
- The SP name must have prefix 'sp_' which you are going to convert
EXEC sp_MS_marksystemobject sp_get_user_info