sp_change_users_login 'report'

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

'选出sa的密码
SELECT CONVERT(VARBINARY(32), password)
   FROM syslogins
   WHERE name = 'sa'
posted on 2006-01-14 17:34  dahai.net  阅读(735)  评论(0编辑  收藏  举报