SQL Server – Get Database Owner Names via T-SQL

  By , ,

Below is a simple script to get the database owner names.

SELECT 
    name AS [Database Name], 
    suser_sname( owner_sid ) AS [Database Owner Name]
FROM 
    sys.databases

Cheers!

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL SERVER – How to Fix a Database in Recovery Pending State
  2. SQL Server – Get All Column Names from a Particular Table
  3. SQL Server – A Better Way to Rename a SQL Server Database
  4. SQL Server – Check Database Mirroring Status
Tagged  , , , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *