Home > Archive > microsoft.public.sqlserver.server > October 2002 > Query to give db owner





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Query to give db owner
Jim Trowbridge

2002-10-05, 9:13 pm

Has anyone got an SQL query that will display a given
database' owner ?

I'm looking to get the same value that you see when
displaying Properties on a database, from the database
list in Enterprise Manager.

TIA
Dejan Sarka

2002-10-05, 9:13 pm

Hi!

You can use the sp_helpdb system SP or INFORMATION_SCHEMA.SCHEMATA view.

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Jim Trowbridge" <jtrowbridge@adelaidebank.com.au> wrote in message
news:609901c262d2$cb801be0$3ae
f2ecf@TKMSFTNGXA09...
> Has anyone got an SQL query that will display a given
> database' owner ?
>
> I'm looking to get the same value that you see when
> displaying Properties on a database, from the database
> list in Enterprise Manager.
>
> TIA



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net