Archive for May 28th, 2009

How to create system stored procedure in SQL Server 2005

Thursday, May 28th, 2009

In other words how to create a procedure visible in any user database.
1. Start the server in single user mode:
   sqlservr.exe -m -s SQLEXPRESS
2. Make mssqlsystemresource writable:
   alter database [mssqlsystemresource] set read_write
3. Create the procedure:
   create proc sys.sp_demo
as
return 9
   NOTE: The procedure name must start with sp_ to make create statement [...]