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
3 comments:
really Gr8 Tips from your side...
Keep posting such knowledgeable things......
really Gr8 Tips from your side...
Keep posting such knowledgeable things......
Aivivu chuyên vé máy bay, tham khảo
vé máy bay đi Mỹ Vietnam Airline
vé máy bay từ mỹ về việt nam
ve may bay tu canada ve viet nam
vé từ nhật bản về việt nam
đặt vé máy bay từ hàn quốc về việt nam
Vé máy bay từ Đài Loan về VN
khách sạn cách ly ở sài gòn
chuyến bay chuyên gia
Post a Comment