SP's Microsoft SQL Server Tips & Tricks
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment