| 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