Database Owner Name

Posted: October 15, 2012 by Virendra Yaduvanshi in Database Administrator
Tags: , , , , ,
2

Its happened sometimes developer or DBA needs to know Database owner,

Here are some basic tips to find out Database owner,

Select  Name as ‘Database Name’,suser_sname(owner_sid) ‘Database Owner’ from sys.databases

– OR – –
Select  Name as ‘Database Name’,suser_sname(sid) ‘Database Owner’ from sysdatabases

Note : suser_sname returns name associated with a security identification number (SID).

Comments
  1. nova group says:
    October 16, 2012 at 9:03 am

    I appreciate, cause I found exactly what I was looking for. You’ve ended my four day long hunt! God Bless you man. Have a great day. Bye

    Like

    Reply
  2. Virendra Yaduvanshi says:
    October 16, 2012 at 12:47 pm

    Thanks Dear, You can ask any question any time…..

    Like

    Reply

Leave a comment