dbo can't bring DB online

I have a user with db_owner status who can take a DB offline, but for some r
eason can't bring it back online. The DB is on a cluster server. Is there an
y way to explicitly script or set this ability for SQL Server 2000? Thanks.Hi Journika
Database role membership is only stored in the database itself. So once the
database is offline, there is no way to know who is in the db_owner role of
the offline database. Bringing the db back online will have to be done by
someone with privilege at the server level, or by the true owner of the
database, as listed in sysdatabses (and viewed through sp_helpdb)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Journika" <anonymous@.discussions.microsoft.com> wrote in message
news:3CFB7F32-C517-4818-8AEC-7A9B135F3017@.microsoft.com...
> I have a user with db_owner status who can take a DB offline, but for some
reason can't bring it back online. The DB is on a cluster server. Is there
any way to explicitly script or set this ability for SQL Server 2000?
Thanks.