Tuesday, January 18, 2011

Add BUILTIN\Administrators to Login

USE master

go

EXEC sp_grantlogin 'BUILTIN\Administrators'

go

EXEC sp_defaultdb 'BUILTIN\Administrators', 'master'

go

EXEC sp_defaultlanguage 'BUILTIN\Administrators', 'us_english'

go

EXEC sp_addsrvrolemember 'BUILTIN\Administrators', 'sysadmin'

go

IF EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname='BUILTIN\Administrators')

PRINT '<<< CREATED LOGIN BUILTIN\Administrators >>>'

ELSE

PRINT '<<< FAILED CREATING LOGIN BUILTIN\Administrators >>>'

go

No comments: