SQL Server 2005 @@VERSION Service Pack level

HI. I've applied SP2 to an instance of SQL Server 2005 yet @@VERSION is still reporting SP1. Anyone any idea why this should be?

Regards,

YaHozna.
YaHoznaAsked:
Who is Participating?
 
patriktCommented:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
the SP1 in the @@VERSION is the one of Windows, and not the one of SQL Server:
http://support.microsoft.com/kb/321185
0
 
YaHoznaAuthor Commented:
Thanks for the info guys. I'll split the points if that's OK?

Regards,

YaHozna.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.