首先选择本数据库 SQL查询分析器 输入以下代码执行:
程序代码sp_configure 'allow updates','1'
go
reconfigure with override
go
update sysobjects set uid=1 where uid<>1
go
sp_configure 'allow updates','0'
go
reconfigure with override
go
reconfigure with override
go
update sysobjects set uid=1 where uid<>1
go
sp_configure 'allow updates','0'
go
reconfigure with override
然后再到库内用户选项里把孤立帐户删除即可
程序代码USE master
Select *
FROM sysusers
Where uid >= '1'
Select *
FROM sysusers
Where uid >= '1'
