derekmurawsky/gist:7751173

Last active December 30, 2015 00:39

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/derekmurawsky/7751173.js"></script>
Save derekmurawsky/7751173 to your computer and use it in GitHub Desktop.

Download ZIP

Add BUILTIN\Administrators as a sysadmin is MSSQL. This was broken/fixed, depending on your POV, in newer versions of SQL server. This will restore it. Be aware, this is a security risk and was changed for a reason.

Raw

gistfile1.sql

	EXEC sp_grantlogin 'BUILTIN\Administrators'
	EXEC sp_addsrvrolemember 'BUILTIN\Administrators','sysadmin'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment