Cloud & SQLSailor

Cloud, Databases & Beyond!

Category: Missing Patch Issues

March 7, 2016

Curious case of SYS.MESSAGES

A strange error struck me last week, and this post is all about that. What you normally expect when you run SELECT * FROM sys.messages? The query will return a row…
March 15, 2013

Apply CU2 for SQL2012 SP1 – Fix for Windows Installer starting repeatedly and causing CPU spikes !

CU2 for SQLServer 2012 SP1 is one key update which you should review and deploy if found necessary. I have found this very much needed for all my SQL2012 SP1…
July 17, 2012

Edit job error ” Creating an instance of the COM component with CLSID {ZZZ} from the IClassFactory failed “

Recently my friend told me that he is hitting a weird error whenever he tries to edit a job using SSMS from his machine. I walked to his desk to…
November 11, 2011

“There is insufficient system memory in resource pool ‘internal’ to run this query”

During Initial versions(RTM) of SQL 2008 and R2 I have observed multiple posts related to the error “There is insufficient system memory in resource pool ‘internal’ to run this query”.…
March 22, 2011

SQL Server 2005 in Windows Server 2008 R2 Error “The SQL Server FullTextSearch (MSSQLSERVER) service depends the following service: NTLMSSP. This service might not be installed.”

Full text search service will be offline and effort to make it online will fail.When you check the logs you can see the error “The SQL Server FullTextSearch (MSSQLSERVER) service…