Tuesday, August 17, 2010

Find owner of database thru T-SQL

For all the database

select suser_sname(owner_sid) from sys.databases

For specific database

select suser_sname(owner_sid) from sys.databases where name = 'Northwind'

No comments:

Post a Comment