sys.sp_addlogin

Description

Creates a new SQL Server login that allows a user to connect to an instance of SQL Server by using SQL Server authentication. This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. When possible, use Windows authentication.

Syntax

sp_addlogin
[ @loginame = ]
N
'loginame'
[ , [ @passwd = ]
N
'passwd'
]
[ , [ @defdb = ]
N
'defdb'
]
[ , [ @deflanguage = ]
N
'deflanguage'
]
[ , [ @sid = ] sid ]
[ , [ @encryptopt = ]
'encryptopt'
]
[ ; ]