How to get Database Owner?

Question

How to get Database Owner?

zeo

SSC Eights!

Points: 914
More actions
November 7, 2003 at 10:33 am

#76076

How do I query a sql server database to get the owner of the database? Which data dictonary views/tables have the information?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jonathan SSC-Insane Points: 20427 More actions · Answer 1

sp_helpdb

Or



SELECT name, sid, SUSER_SNAME(sid)

FROM master..sysdatabases

--Jonathan

zeo SSC Eights! Points: 914 More actions · Answer 2

quote:

sp_helpdb

Or



SELECT name, sid, SUSER_SNAME(sid)

FROM master..sysdatabases

--Jonathan

Why do you need an extra '.' when querying from sysdatabases

mimorr SSCarpal Tunnel Points: 4850 More actions · Answer 3

Because he is not inserting the table owner name. If he used master.dbo.sysprocesses then he wouldn't need the double '..' DBO is assumed if the owner(schema) not specified.

Hope this helps (HTH)

Michelle

zeo SSC Eights! Points: 914 More actions · Answer 4

zeo

SSC Eights!

Points: 914

November 7, 2003 at 1:47 pm

#481318

thank you