Contained Database

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)

Tags: ,

SQL Server Denali

Category

Recent Posts

Tag cloud