enteams
Snippet Name: enteams
Tags: helpful,scriptgeneration
Created Date: Oct 1 2021 8:05AM
Last Modified Date: Oct 1 2021 8:05AM
–desc: timesaver to paste the command to add the DBA group as sysadmin
Dependencies: none-standalone code
Sample Output:
--desc: timesaver to paste the command to add the DBA group as sysadmin
USE [master]
GO
IF SUBSTRING(CONVERT(VARCHAR(128),@@SERVERNAME),4,1) = 'P'
BEGIN
IF NOT EXISTS(SELECT * FROM sys.server_principals WHERE name = 'US1\DataManagementN')
CREATE LOGIN [US1\DataManagementN] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
EXECUTE sys.sp_addsrvrolemember @loginame = 'US1\DataManagementN', -- sysname
@rolename = 'sysadmin' -- sysname
END
ELSE IF SUBSTRING(CONVERT(VARCHAR(128),@@SERVERNAME),4,1) IN('D','S')
BEGIN
IF NOT EXISTS(SELECT * FROM sys.server_principals WHERE name = 'US1\DataManagement')
CREATE LOGIN [US1\DataManagement] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
EXECUTE sys.sp_addsrvrolemember @loginame = 'US1\DataManagement', -- sysname
@rolename = 'sysadmin' -- sysname
END