Posts Tagged ‘SQL Server determine database owner’

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