Undocumented stored procedure:: sp_MS_upd_sysobj_category | SansSQL

Wednesday, July 16, 2008

Undocumented stored procedure:: sp_MS_upd_sysobj_category

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

5 comments:

Anonymous said...

really Gr8 Tips from your side...
Keep posting such knowledgeable things......

Anonymous said...

really Gr8 Tips from your side...
Keep posting such knowledgeable things......

Huongkvb said...

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

Gabby said...

The definition of the product and article is mentioned on the site. Clarity of the commodity and Casement windows
for the chunks. This matter is filed for the approval of the reforms for the mixing of the remarks in the favor's of the product.

Micheal Jackson said...

Outsourcing Center
has a reputation for delivering quality results. I'm thinking of partnering with them for our outsourcing needs.

Post a Comment

Ads