How to find the login name of the dbo?

Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to find the login name of the dbo:

USE master;

SELECT SUSER_SNAME(sid)

FROM master..sysdatabases

WHERE name = 'Northwind'

GO

/* Result

sa

*/

Related articles:

ALTER USER (Transact-SQL)

Sql Server 2005 how to change dbo login name