列出sqlserver数据库孤立用户

sp_change_users_login 'report'

'将所有对象所有权给dbo
exec sp_MSForEachTable 'sp_changeobjectowner ''?'',''dbo'''

'选出sa的密码
SELECT CONVERT(VARBINARY(32), password)
   FROM syslogins
   WHERE name = 'sa'

转载于:https://www.cnblogs.com/webcool/archive/2006/01/14/317323.html