Posted by Erland Sommarskog on 08/12/05 00:58

Vithar (cjohnson@cskauto.com) writes:
> I built a database by using a generated script from the original
> database. It built the System Store Procedures as User type. How do I
> change them back to System type?

What database was that? System procedures are really only in master.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: How do I change the Type of a Stored Procedure from User to System?
• Prev in forum: Re: index bloat?
• Thread view: Re: How do I change the Type of a Stored Procedure from User to System?

[Reply to this message]