Creates a login.

sp_addlogin loginame, passwd [,defdb] [,deflanguage] [,fullname] [, passwdexp] [,minpwdlen] [, maxfailedlogins]

Parameter information :
»loginame : Name of the login.
»passwd : Password for the login.
»defdb : Name of the default database for the login. Don't forget to create a user account in that database with sp_adduser.
»deflanguage : Server language to use for the login if it must be different as the default language on the server.
»fullname : Full name of the person.
»passwdexp : Password expiration time in days.
»minpwdlen : Minimum password length
»maxfailedlogins : Number of failed logins before the login will be locked.