Home Forums SQL Server 2008 SQL Server 2008 Administration dbo user in the database has a domain login account RE: dbo user in the database has a domain login account
HildaJ
SSCarpal Tunnel
Points: 4516
More actions
April 29, 2013 at 7:12 am
#1610776
USE YourDatabaseName;
GO
SELECT sp.name
FROM sys.database_principals dp
JOIN sys.server_principals sp ON dp.principal_id = sp.principal_id
WHERE dp.name = 'dbo';
The script above gives me 'domain\username'