You can check out one of my past posts on how to find out which service pack is currently installed on your SQL Server 2005 instance and on how to get the latest service pack.
However, if you are still experiencing the same problem, even in the case you have installed the latest service pack, then you can try running the sql script called “sysdbupg.sql” which can be found in the SQL Server installation directory under the subfolder “install“.
This script upgrades the system database stored procedures from the RTM level. Databases which may be upgraded are:
Make sure before trying to execute the above script, to backup the aforementioned system databases!
A big thanks to my good friend Ioannis for bringing this hint to my attention!
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).