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
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only