Posts Tagged ‘Database owner’

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).