Get the list of db and db owner

• Ak-763166

  Right there with Babe

  Points: 772

  More actions

  April 30, 2009 at 6:00 am

  #133607

  Hi All,

  Is there any script whereby i can get a list of db and the owner ie who created it? I want the same user when i right click on a db to check the owner.

  I tried the below

  select a.name, a.create_date, b.name from sys.databases a

  inner join syslogins b on a.owner_sid =b.sid

  But it omits some of the db.

  Can someone please help.

  Thanks

  A.

• Satish Nagaraja

  SSCrazy

  Points: 2632

  More actions

  April 30, 2009 at 6:14 am

  #986600

  Try customizing the results of system stored procedure run against master database

  use master

  sp_helpdb

  -:-)

  Cheer Satish 🙂

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  April 30, 2009 at 7:08 am

  #986624

  SELECT

  [name]AS [DBName]

  ,SUSER_SNAME([sid])AS [DBOwner]

  FROM [master].[dbo].[sysdatabases]

  ORDER BY 1

• BLADE-1043594

  SSCrazy

  Points: 2576

  More actions

  April 30, 2009 at 7:09 am

  #986625

  sp_helpdb

  [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

• Perry Whittle

  SSC Guru

  Points: 234013

  More actions

  April 30, 2009 at 1:30 pm

  #986897

  Adam Bean (4/30/2009)

  ---

  SELECT

  [name]AS [DBName]

  ,SUSER_SNAME([sid])AS [DBOwner]

  FROM [master].[dbo].[sysdatabases]

  ORDER BY 1

  this should do it

  select [name] as [DB Name], SUSER_SNAME([owner_sid]) AS [DBOwner] from sys.databases

  order by 1

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉