Login: piter

Properties

Property	Value
Login Name	piter
Principal ID	282
Login Type	SQL LOGIN
Enabled
SID	x3C7C9802AFBB9D47832E07DFBBE701C9
Default Database	master
Default Language	us_english
Default language friendly name	English
Enforce Password Policy
Enforce Password Expiration
Password Expired
User must change password at next login
Login is locked out
Permission to connect to database engine
Mapped to certificate
Mapped to asymmetric key
System Object
Last Modify Time	1/11/2012 3:33:00 PM
Create Time	11/29/2011 2:19:42 PM

Login mapped to credentials

Login is not mapped to any credential

Login mapped to database users

Login is not mapped to any database users

Server Roles for that login

Role Name
sysadmin

Login Permissions on the server

No Server Permissions defined for that login

SQL

Script
/* For security reasons the login is created disabled and with a random password. / CREATE LOGIN [piter] WITH PASSWORD=***********************, DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON EXEC sys.sp_addsrvrolemember @loginame = N'piter', @rolename = N'sysadmin' ALTER LOGIN [piter] DISABLE

See also