Hi
I'm working with SQL 2000 and I want to view the properties of Sa login by
right clicking on it ,but when I did it ,at first a following message
appearred before the properties window,
'Error 21776 : the name dbo was not found in the users collection. if the
name is a qualified name use [] to separate various parts of the name and
try again.'
and when I went to the last tab of properties for some of my databases just
'public' access was selected for sa!! and when I want to select db_owner too
above error again happened,
how can I repair my problem?
Any help would be greatly thanful.MR
http://www.cryer.co.uk/brian/sqlserver/error21776.htm
"M R" <rezvani@.parskhazar.net> wrote in message
news:%23CMqJJ4UFHA.2168@.TK2MSFTNGP10.phx.gbl...
> Hi
> I'm working with SQL 2000 and I want to view the properties of Sa login by
> right clicking on it ,but when I did it ,at first a following message
> appearred before the properties window,
> 'Error 21776 : the name dbo was not found in the users collection. if the
> name is a qualified name use [] to separate various parts of the name and
> try again.'
> and when I went to the last tab of properties for some of my databases
just
> 'public' access was selected for sa!! and when I want to select db_owner
too
> above error again happened,
> how can I repair my problem?
> Any help would be greatly thanful.
>
No comments:
Post a Comment