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'
Labels: ,

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

May 31, 2011 6:02 PM
Ramseize said...

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

September 10, 2011 10:29 AM

Post a Comment

Subscribe to: Post Comments (Atom)