Fixing SQL Server SSL Error: The Certificate Chain Was Issued by an Untrusted Authority
When connecting to SQL Server, you might encounter this login error: “A connection was successfully established with the server, but…
Category: Database
SQL Server Issue – SQL Server Database struck in Recovery Mode
Scenario: We can not restore the same with latest backup because the DB is critical and there is no latest…
SQL Server – How to run a query for all the database(s) in SQL Server Instance
We will use sp_MSforeachdb procedure which is an undocumented procedure that allows you to run the same command against all…