今天为SQL SERVER 2005打了SP3的补丁,重启服务器用windows登录数据库后,右键点击数据库的属性,居然提示如下错误:、
Property Owner is not available for Database '[XXX]'.This property may not exist for this object,or may be retrievable due to insufficient access rights.(Microsoft.SqlServer.Smo)
各位帮忙看看是怎么回事
Property Owner is not available for Database '[XXX]'.This property may not exist for this object,or may be retrievable due to insufficient access rights.(Microsoft.SqlServer.Smo)
各位帮忙看看是怎么回事
FROM sys.[databases]
INNER JOIN sys.[server_principals]
ON [databases].owner_sid = [server_principals].sid
发现sa不是该数据库的owner??????!
用如下语句将该数据的owner列表中增加了sa
use XXXXX
EXEC sp_changedbowner 'sa'
GO