Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

Creates a new SQL Server login and then maps that login to a new database user

USE Master GO sp_addlogin 'Paul',  --USE AdventureWorks2000 GO sp_grantdbaccess 'Paul', SQL Server 2000 Windows login: