hi,
i want to create the system store procedure and why to use in programming.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jaganathan BantheswaranPosted Apr 26, 2011, 6:20 AM
System stored procedure is nothing but any stored procedure with a name that starts with sp_ that is found in the master database.
These SP's can be executed from any database and will run from the context of that database.
Any time you execute an SP that starts with sp_ SQL Server goes directly to the master database to find it.
For more details, click