If you find AlwaysOn Health Events grayed out and you are not able to see extended events.  Please find below screenshot. When you connect Dashboard of AlwaysOn, you will find View AlwaysOn Health Events grayed out (Below screenshot is not grayed out, this is to… Read More

Below Script is to copy one particular database role from one SQL server to another  declare @RoleName varchar(50) = ‘Database_Role_Name’ declare @Script varchar(max) = ‘CREATE ROLE ‘ + @RoleName + char(13)select @script = @script + ‘GRANT ‘ + prm.permission_name + ‘ ON ‘ + OBJECT_NAME(major_id)… Read More