A departed user’s account kept being added automatically to SharePoint database roles. How to catch who adds it, and from where, on SQL Server 2025.
SQL SERVER – xp_cmdshell and Net Use ERROR: The Local Device Name is Already in Use
Mapping a share with net use through xp_cmdshell, I hit “The local device name is already in use”. Here is what causes this error and how to solve it.
SQL SERVER – Linked Server Error: TCP Provider: No Connection Could be Made Because the Target Machine Actively Refused It
Creating a linked server failed its connection test: No connection could be made because the target machine actively refused it. Here is what to check.
SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005
While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error.
SQL SERVER – Error: 17300 – SQL Server Was Unable to Run a New System Task
They noticed that application jobs are failing with the below error message about running a new system task. Let us learn more about this.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.
SQL SERVER – Msg 32055 – sp_refresh_log_shipping_monitor – There Was an Error Configuring the Remote Monitor Server
Msg 32055, error configuring the remote monitor server, hides the real error. Read from the procedure on SQL Server 2025, with a safer fix than sa.