本文介绍了一种在SQL Server中手动修改系统表的方法，包括允许更新配置、更改对象所有者等步骤。此操作需要谨慎处理，以免影响数据库的稳定性和安全性。
--手动修改系统表
--设备可以手动修改表
exec sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
--更改对象所有者
update sysobjects set uid = 1 where uid = 5
update sysobjects set uid = 5 where uid = 1 AND xtype != 'S'
update sysobjects set uid = 1 where name = 'syssegments'
update sysobjects set uid = 1 where name = 'sysconstraints'
exec sp_configure 'allow updates',0
RECONFIGURE WITH OVERRIDE
--设备可以手动修改表
exec sp_configure 'allow updates',1
RECONFIGURE WITH OVERRIDE
--更改对象所有者
update sysobjects set uid = 1 where uid = 5
update sysobjects set uid = 5 where uid = 1 AND xtype != 'S'
update sysobjects set uid = 1 where name = 'syssegments'
update sysobjects set uid = 1 where name = 'sysconstraints'
exec sp_configure 'allow updates',0
RECONFIGURE WITH OVERRIDE
扫一扫
1万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
