Skip to content

Instantly share code, notes, and snippets.

@mvillegascuellar

mvillegascuellar/copydb_createlogin_dest.sql

Created June 11, 2018 22:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mvillegascuellar/3ced4e98965d3af409c6df2e9f61313d to your computer and use it in GitHub Desktop.
Save mvillegascuellar/3ced4e98965d3af409c6df2e9f61313d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
copydb_createlogin_dest.sql
--En la base de datos master
CREATE LOGIN CopyLogin WITH PASSWORD = 'My$ecurePa$$w0rd'
GO
CREATE USER CopyLogin FOR LOGIN CopyLogin
GO
ALTER ROLE dbmanager ADD MEMBER CopyLogin;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment