PDA

View Full Version : How to detect the SP of MSDE aside from CSDVersion?



SnowBoy
03-21-2007, 12:14 AM
CSDVersion wrong in registry on MSDE Service Pack 4:

I've just applied MSDE service pack 4 to an MSDE SP3 installation (a
non-blank instance). I find that the registry entry which should give me
the SP build number (HKLM\Software\Microsoft\Microsoft SQL
Server\<instance>\MSSQLServer\CurrentVersion, value CSDVersion) gives me
8.00.1100, even though SELECT @@VERSION gives 8.0.2039 (which I gather is the correct number).

Where does this 1100 come from?