question about my mssql environment requested by vendor

schema name for the "john.doe" user account
this is a sql user and not a domain user account


how to i retrieve this information?

sql server 2008
jamesmetcalf74Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
teebonConnect With a Mentor Product ManagerCommented:
Hi James,

You can run this query to check

SELECT * FROM sys.database_principals where (type='S' or type = 'U')

Open in new window

0
 
jamesmetcalf74Author Commented:
Hi
that did retrieve some of the users but less than half and not the one i needed...
0
All Courses

From novice to tech pro — start learning today.