how to mark store procedure as system object?

how to mark store procedure as system object?

Post by Dickso » Wed, 09 Jun 1999 04:00:00



Anyone know how to mark store procedure as system object? Thanks in
advance.
 
 
 

how to mark store procedure as system object?

Post by Tony Rogerso » Wed, 09 Jun 1999 04:00:00


Put it in the master database and prefix it with sp_ this will then be
accessible like the rest of the system stored procedures.

--
Tony Rogerson MCP,SQL Server MVP
Torver Computer Consultants Ltd.

Home page: www.sql-server.co.uk (under construction)


Quote:> Anyone know how to mark store procedure as system object? Thanks in
> advance.


 
 
 

how to mark store procedure as system object?

Post by James Olse » Wed, 09 Jun 1999 04:00:00


place them in master database and prefix them with sp_

Quote:> Anyone know how to mark store procedure as system object? Thanks in
> advance.