SQLUSA
FREE TRIAL  CLICK HERE TO ORDER  SEARCH
SQL Server 2008 Training Scripts
SQL Server 2005 Training Scripts
SQL Server Training Scripts
SQL 2008 GRAND SLAM
How to find the login name of the dbo?

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

USE master;

 

SELECT SUSER_SNAME(sid)

FROM master..sysdatabases

WHERE name = 'Northwind'

GO

/* Result

 

sa

*/

 

 

The World Leader in SQL Server 2008 Training
Order SQL 2008 GRAND SLAM Today!
The Future is just a CLICK away! Your Future!
SQLUSA.com Home Page

Copyright 2005-2010, SMI Corp. All Rights Reserved.

SQL Server 2008 is a program product of Microsoft Corporation.
SQL Server 2005 is a program product of Microsoft Corporation.
SQL Server 2000 is a program product of Microsoft Corporation.