[MSSQL]将用户表 存储过程 变成系统的

将用户表变成系统表
exec sp_configure 'allow updates',1 reconfigure with override
UPDATE sysobjects SET status = status | 0x80000000 WHERE [NAME] = '表名称'
exec sp_configure 'allow updates',0 reconfigure with override

还原
exec sp_configure 'allow updates',1 reconfigure with override
UPDATE sysobjects SET status = status & 0x7FFFFFFF WHERE [NAME] = '表名称'
exec sp_configure 'allow updates',0 reconfigure with override

 

http://blog.csdn.net/wangjia184/archive/2005/12/24/560950.aspx