Login: cart

Properties

Property	Value
Login Name	cart
Principal ID	264
Login Type	SQL LOGIN
Enabled
SID	x215E61E5C0EA3B4A8645C54DA93D5B73
Default Database	Cart
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	9/19/2010 3:22:15 AM
Create Time	8/2/2010 6:06:27 PM

Role Name
dbcreator

Permission	Grantor	Grant	With Grant	Deny
Administer Bulk Operations	sa
Alter
Alter Any Credential
Alter Any Connection
Alter Any Database
Alter Any Event Notification
Alter Any Endpoint
Alter Any Login
Alter Any Linked Server
Alter Resources
Alter Server State
Alter Settings
Alter Trace
Authenticate Server
Control Server
Control
Create Any Database
Create DDL Event Notification
Create Endpoint
Create Trace Event Notification
Impersonate
Shutdown
Take Ownership
View Definition
View Any Definition	PROJECTENVISION\krystian.zieja
View Any Database
View Server State
External Access

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