Name: | BUILTIN\Administrators |
Friendly Name: | English |
System: | |
Default Database: | master |
Deny Windows Security Authenticated Connections: | |
Type: | Windows security group |
Permissions to Access the Server: |
Role | |
|
sysadmin |
if not exists (select * from master.dbo.syslogins where loginname = N'BUILTIN\Administrators')
exec sp_grantlogin N'BUILTIN\Administrators'
exec sp_defaultdb N'BUILTIN\Administrators', N'master'
exec sp_defaultlanguage N'BUILTIN\Administrators', N'us_english'
GO
See Also
Server overview