SQL Ops Studio - User Snippets

sql.json

{
	"New SQL Login": {
		"prefix": "new-sql-login",
		"body": [
			"CREATE LOGIN [${1:name of the login}] WITH PASSWORD = N'${2:password value}', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF;",
		],
		"description": "Create a new SQL Login"
	},
	"New Windows Login": {
		"prefix": "new-windows-login",
		"body": [
			"CREATE LOGIN [${1:name of the login}] FROM WINDOWS;",
		],
		"description": "Create a new Windows Authentication Login"
	}
}