SQL Server 2012: T-SQL script to convert a Database to Partial Contained Database

This article is half-done without your Comment! *** Please share your thoughts via Comment ***

The feature of Contained Databases introduced with SQL Server 2012 and SQL DBAs are using this feature for those databases which are frequently required to move between SQL Server Instances. If you don’t know about Contained database, please read previous two articles.

In this post, I am sharing a T-SQL script to convert your current database to Partially Contained Database of SQL Server.

You can also change this setting using SSMS, Right click on Database -> Options -> Containment type -> Partial

Enable Contained Database feature at instance level:

Alter your database for CONTAINMENT: