Monday, March 26, 2012

No dbo in the database!

Hi All
I have a database where there is no dbo user. There seems
to be some login mismatch that I can't fix up.
The master shows sa (in fact sa is the dbo in another db
on the same server) but sa, dbo does not appear in one of
the other databases and I can't add it.
I've checked out KB 305711 but it doesn't help.
Thanks
JIn Query Analyzer,
USE the database and issue this command:
EXEC sp_changedbowner 'sa'
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"J" <anonymous@.discussions.microsoft.com> wrote in message
news:000501c3af13$941724d0$a001280a@.phx.gbl...
> Hi All
> I have a database where there is no dbo user. There seems
> to be some login mismatch that I can't fix up.
> The master shows sa (in fact sa is the dbo in another db
> on the same server) but sa, dbo does not appear in one of
> the other databases and I can't add it.
> I've checked out KB 305711 but it doesn't help.
> Thanks
> J

No comments:

Post a Comment