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
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

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

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

From novice to tech pro — start learning today.