Skip to content

Instantly share code, notes, and snippets.

@jammykam

jammykam/Contained_Database_Authentication.sql

Created November 16, 2017 01:51
Show Gist options
  • Save jammykam/00aca7e89469f7b3fdc6943f11fe1fcd to your computer and use it in GitHub Desktop.
Save jammykam/00aca7e89469f7b3fdc6943f11fe1fcd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Contained_Database_Authentication.sql
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment