« Wireshark Version 1.0.7 (SVN Rev 28014) on Mac OS X 10.5.6 | Home | Rick Rashid: Leading Microsoft into the Future with Research »
How to create system stored procedure in SQL Server 2005
By Мартин | May 28, 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 succeed.
4. Mark the procedure as ’system’:
execute mssqlsystemresource.sys.sp_SetPublicInterfaceObject 'sp_demo'
5. Revert mssqlsystemresource mode:
alter database [mssqlsystemresource] set read_only
Topics: Misc |