Creating System Stored Procedures

So what are the steps to creating a systemwide stored procedure in SQL Server?

• Create them in the Master Database
• Name must start with "sp_"
• Mark them as System Objects using
• for sql 2000 - master.dbo.sp_MS_upd_sysobj_category
• For 2005 and later - sys.sp_MS_marksystemobject

For a test in 2008:

1. Create a stored procedure in the system databaseone called sp_test
2. Register them as system stored procs using sp_MS_marksystemobject.
3. Then try to use them each from another database without prefixing them with master.dbo.