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