This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In the previous article, I shared a small note on SQL Server 2012 Contained Database. In this script, I am sharing a script to enable Contained Database at an instance level.
Without enabling this option, you cannot create a Contained Database in SQL Server 2012. Use sp_configure to enable it and require option is ‘contained database authentication.’
Below is a script:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
Use master GO sp_configure 'show advanced options', 1 GO RECONFIGURE WITH OVERRIDE GO sp_configure 'contained database authentication', 1 GO RECONFIGURE WITH OVERRIDE GO sp_configure 'show advanced options', 0 GO RECONFIGURE WITH OVERRIDE GO |
Leave a Reply