Skip to content
Tim's Devops Patterns
  • SEARCH
  • DOCS
    • GNU/Linux
    • MSSQL Server
    • MySQL Server
    • XML
    • PowerShell Scripting
    • MS Windows Server
    • Other
  • ABOUT
Tim's Devops Patterns
  • SEARCH
  • DOCS
    • GNU/Linux
    • MSSQL Server
    • MySQL Server
    • XML
    • PowerShell Scripting
    • MS Windows Server
    • Other
  • ABOUT

MSSQL Connect Database User to Login

By Tim van Kooten Niekerk / MSSQL Server / 2009-06-04

The script below connects an existing user in the database to an existing server login.

USE [DATABASE]
ALTER USER DbUser WITH LOGIN = [LoginUser]
GO
← Previous Post
Next Post →

Related Posts

MSSQL JOIN Selection Queries

MSSQL Server / By Tim van Kooten Niekerk

INNER JOIN: Only records with joing fields in both tables. LEFT OUTER JOIN: All records from table 1 and only matching fields from table 2…

MSSQL Create Unique Constraints

MSSQL Server / By Tim van Kooten Niekerk

Example to create a unique constraint on a column. ALTER TABLE tablename ADD CONSTRAINT CK_Columnname UNIQUE (Columnname)  

TIM'S DEVOPS PATTERNS

  • PRIVACY
  • COPYRIGHT
  • ABOUT