sp_MS_upd_sysobj_category is an undocumneted stored procedure which Enables or disables a special system mode where all newly created objects are automatically shown as system objects in enterprise manager. sp_MS_upd_sysobj_category accepts a parameter @Mode. @Mode can either be 1 or 2. Setting the value of @Mode to 1 enables this special system mode and setting it to 2, disables it. Among other things, sp_MS_upd_sysobj_category allows the creation of user-defined INFORMATION_SCHEMA views.
Usage:
EXEC master.dbo.sp_MS_upd_sysobj_category @Mode
@Mode = 1 or 2
1=Enable
2=Disable
Enable special system mode:
EXEC master.dbo.sp_MS_upd_sysobj_category 1
Disable special system mode:
EXEC master.dbo.sp_MS_upd_sysobj_category 2
Wednesday, July 16, 2008
Subscribe to:
Post Comments (Atom)
2 comments:
really Gr8 Tips from your side...
Keep posting such knowledgeable things......
really Gr8 Tips from your side...
Keep posting such knowledgeable things......
Post a Comment