Merge pull request microsoft#917 from TDzakhov/master

Updated release notes and ruleset.json
azurewood · Mar 25, 2021 · 69ff572 · 69ff572
2 parents e6466b6 + 09ffa97
commit 69ff572
Show file tree

Hide file tree

Showing 3 changed files with 10 additions and 2 deletions.
diff --git a/samples/manage/sql-assessment-api/.DS_Store b/samples/manage/sql-assessment-api/.DS_Store
diff --git a/samples/manage/sql-assessment-api/release-notes.md b/samples/manage/sql-assessment-api/release-notes.md
@@ -14,6 +14,14 @@ Download: [SMO NuGet Package](https://www.nuget.org/packages/Microsoft.SqlServer
 
 You can use GitHub issues to provide feedback to the product team.
 
+## March 2021 - 1.0.305
+
+Version: SqlServer PowerShell module wasn't updated, SqlManagementObjects (SMO) package wasn't updated
+
+### Bug fixes and improvements
+
+- Fixed an issue that may cause the 'ReplErrors24H' check to fail on case-sensitive SQL Server instances with Distributor databases
+
 ## March 2021 - 1.0.304
 
 Version: SqlServer PowerShell module wasn't updated, SqlManagementObjects (SMO) package wasn't updated

diff --git a/samples/manage/sql-assessment-api/ruleset.json b/samples/manage/sql-assessment-api/ruleset.json
@@ -1,7 +1,7 @@
 {
   "schemaVersion": "1.0",
   "name": "Microsoft ruleset",
-  "version": "1.0.304",
+  "version": "1.0.305",
   "rules": [
     {
       "id": "AutoCreateStats",
@@ -8871,7 +8871,7 @@
           "version": "[11.0,)"
         },
         "implementation": {
-          "query": "DECLARE @cmd NVARCHAR(max) = N''; SELECT @cmd = @cmd + N' USE ' + QUOTENAME([name]) + N'; SELECT msa.publisher_db ,msa.publication FROM dbo.MSdistribution_history AS msh INNER JOIN dbo.MSrepl_errors AS mse ON mse.id = msh.error_id INNER JOIN dbo.MSdistribution_agents AS msa ON msh.agent_id = msa.id WHERE mse.TIME >= DATEADD(hh, - 24, GETDATE()) GROUP BY msa.publisher_db ,msa.publication;' FROM [master].sys.databases WHERE is_distributor = 1; EXEC (@cmd);"
+          "query": "DECLARE @cmd NVARCHAR(max) = N''; SELECT @cmd = @cmd + N' USE ' + QUOTENAME([name]) + N'; SELECT msa.publisher_db ,msa.publication FROM dbo.MSdistribution_history AS msh INNER JOIN dbo.MSrepl_errors AS mse ON mse.id = msh.error_id INNER JOIN dbo.MSdistribution_agents AS msa ON msh.agent_id = msa.id WHERE mse.time >= DATEADD(hh, - 24, GETDATE()) GROUP BY msa.publisher_db ,msa.publication;' FROM [master].sys.databases WHERE is_distributor = 1; EXEC (@cmd);"
         }
       }
     ],