USE MASTER
GO
DECLARE @PrintSQL BIT = 1,
@ExecSQL BIT = 0
DECLARE @SQL VARCHAR(MAX)
SELECT @SQL = Util.dbo.StringConcat('GRANT VIEW SERVER STATE TO [' + NAME + '];', '
')
FROM sys.server_principals
WHERE type IN ('U', 'G')
AND (name LIKE 'fll%'
OR name LIKE 'firstamdata%'
OR name LIKE 'isc%'
OR name LIKE 'ana%')
IF @PrintSQL = 1
EXEC Util.dbo.PrintLargeText
@SQL
IF @ExecSQL = 1
AND @SQL <> ''
EXEC(@SQL)