by Amol
12. March 2011 03:56
What is contained database and how to create it is explained in earlier post Using Contained Database
Here is SQL query to list out contained database users who can connect to it. Any user like windows, group user or SQL Server user contained in database can connect to contained database
SELECT
principal_id
,name
,type_desc
,authentication_type_desc
FROM db_Contained.sys.database_principals
WHERE authentication_type IN (2, 3)