Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DT_ Stored Proccedures are not system objects
Message
From
07/07/2008 15:52:35
June Kendrick
Kendrick Associates, Inc.
New York, United States
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
DT_ Stored Proccedures are not system objects
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01329574
Message ID:
01329574
Views:
56
I've got a couple of databases where the DT_ stored procedures are not marked as system objects. For the other databases,they are marked as system objects.

Does anyone know why they end up as non-system objects? If I delete them, will they come back as system or user objects? I suppose that might depend on what the user permissions are when invoking the Diagram node in Enterprise Manager, or invoking Server Explorer?

I know I can mark them as system objects with the undocumented sp_MS_markSystemObject, once I get execute permission for the sp.

Thanks,
June
Reply
Map
View

Click here to load this message in the networking platform