Skip to content

Instantly share code, notes, and snippets.

@wsmelton
Created April 26, 2018 22:48
Show Gist options
  • Save wsmelton/e347663c6bdb8d69075298d53b2471dc to your computer and use it in GitHub Desktop.
Save wsmelton/e347663c6bdb8d69075298d53b2471dc to your computer and use it in GitHub Desktop.
SQL Ops Studio - User Snippets
{
"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"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment