One more cause of the script level upgrade failure for ‘sqlagent100_msdb_upgrade.sql’: Error 5041, MODIFY FILE failed. Here is how I fixed it.
SQL SERVER – Full-Text Search Not Working For PDF Documents
A client stored PDF files in a VARBINARY(MAX) column, and Full-Text search could not find text in them. Here are all the steps I used in my lab to make it work.
SQL SERVER – Installation Error: The Cluster Resource is Not Available. (Exception from HRESULT: 0x8007138E)
Patching SQL Server on a cluster failed with: The cluster resource is not available (HRESULT 0x8007138E). Here is how the Summary.txt file led to the fix.
SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?
During a rushed release, a client stopped SQL Server and the service got stuck. Here is what Change Pending State in Configuration Manager means and what to do.
SQL SERVER – Fix – Error – Property MemoryAllocatedToMemory OptimizedObjectsInKB is not available for Database. This property may not exist for this object, or may not be retrievable due to insufficient access rights.
The MemoryAllocatedToMemory OptimizedObjectsInKB error popped up while I was teaching a workshop. It is a permissions issue, and one command fixes it.
SQL SERVER – Unable to Repair – SQL_Telemetry_Repair_Startup_Cpu64 gives error – The Service Cannot Be Started
SQL SERVER – Unable to Repair – SQL_Telemetry_Repair_Startup_Cpu64 gives error – The Service Cannot Be Started
SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly
Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.