Updates for all sp_Check tools – March 2026

As promised last month, we are planning for (at least) monthly updates of our FREE sp_Check stored procedures, so here are the March updates.

This month we did change the “ReadMore” URL links in the results of all tools to not use redirects. This might have been causing issues for folks who just wanted some more info about the findings in our tools, and we apologize if you were one of those folks.

Speaking of URLs, we found a bunch that didn’t work because the wording was wrong. We’re not sure how this happened, but we will get these fixed in the April updates.

This month though there are mostly a few small updates for the tools, as next month’s updates should also include many of the issues noted in GitHub (thanks for those!) Most of this month’s updates were to sp_CheckSecurity, although we did add “Initial File Size” to the output of sp_CheckTempdb since that had been requested by a few folks.

We hope these new updates can help you, especially if you’ve never used these stored procedures. Here are the updates for March 2026, with links to the GitHub repositories where you can download the latest versions.

sp_CheckAG

• CHANGE all Straight Path URLs to not involve redirects
• Change High HADR_SYNC_COMMIT waits to avoid arithmetic overflow (CheckID 422)

sp_CheckBackup

• CHANGE all Straight Path URLs to not involve redirects
• ADD check for password protected backups (CheckID 215)

sp_CheckSecurity

• CHANGE all Straight Path URLs to not involve redirects
• CHANGE check for most recent version for SQL Server security updates
• CORRECT inconsistent recommendation for Database owner discrepancy (CheckID 306)
• CHANGE Database owner discrepancy (CheckID 306) to only check online databases
• CHANGE Service Account using local elevated account (CheckID 329) to include the SQL Agent service.
• CHANGE Service Account in sysadmin role (CheckID 350) to include the SQL Agent service.
• ADD check for SQL Server services in local Administrators group (CheckID 351)

sp_CheckTempdb

• CHANGE all Straight Path URLs to not involve redirects
• Add InitialFileSize to @Mode = 1
• Remove ordinal values from ORDER BY in @Mode = 1