Contained database in SQL server | How to create a contained database | Ms SQL
Contained databases feature is available at instance level and it is not enabled by default.
If we want to create a new database as a contained database, we have to make containment type as Partial in the Options page.
Contained database feature provides two containment modes:
None – By default each database has its mode set as NONE. This means there is no contained database feature being used.
Partial – With partially contained databases, we can define boundaries between databases and the server, so the metadata will exist inside the databases. It makes SQL Server databases more portable and less dependent on underlying hosts.
Before allowing contained databases, one should understand the risks associated with contained databases. Click below link to check the Best Practices with Contained Databases.
https://learn.microsoft.com/en-us/sql...
--To check if database is contained
select containment,name from sys.databases where name='DEMO'
--To check which users are listed as contained users
SELECT name,type_desc,authentication_type_desc
FROM sys.database_principals WHERE authentication_type =2
Please watch complete video for a better understanding @righttolearnbk
En esta página del sitio puede ver el video en línea Contained database in SQL server | How to create a contained database | Ms SQL de Duración hora minuto segunda en buena calidad , que subió el usuario Right to Learn @BK 01 enero 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 3,144 veces y le gustó 82 a los espectadores. Disfruta viendo!
