How to: create login with 'sa' credentials

CREATE LOGIN loginname
WITH PASSWORD = 'changeme' MUST_CHANGE
,CHECK_EXPIRATION = ON
,DEFAULT_DATABASE = DBName
GO
EXECUTE sp_addsrvrolemember
@loginame = 'loginname',
@rolename = 'sysadmin'

2 comments:

Hemraj said...

Hi, Some one from facebook refereed your link i have book marked it nice blogs you write see Free Adwords Voucher here

Ramseize said...

nice tut, salamat : http://pinoygeeks.net