How to create system store procedure ?

Question

hi i want to create the system store procedure and why to use in programming.

Jaganathan Bantheswaran · Answer

Hi 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