Login: sa

Collapse All Expand All

Login Properties

Name	Value
Name	sa
Friendly Name	English
Language	us_english
System
Default Database	master
Deny Windows Security Authenticated Connections
Type	SQL Server standard login
Permissions to Access the Server	N/A

Users with this login

	Database	User
	master	dbo
	tempdb	dbo
	model	dbo
	msdb	dbo
	CASH	dbo
	DATAEXCH	dbo
	HOLDING	dbo
	PACE_MASTER	dbo
	RULES	dbo
	SCRUB	dbo
	SECURITY	dbo
	TRADES	dbo

Roles with this login

	Role
	sysadmin

SQL

CREATE LOGIN [sa] WITH        
    PASSWORD = 'p@ssw0rd',
    SID = 0x01,
    DEFAULT_DATABASE = [master],
    DEFAULT_LANGUAGE = [us_english],
    CHECK_EXPIRATION = OFF,
    CHECK_POLICY = ON
GO

See also

Buildmasters.com.au