I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1.
Any idea why?
P.S.
I think the installation process is asinine.
Jump to PostYou probably need to restart :-|
You probably need to restart :-|
You probably need to restart :-|
I took my SQL Server offline and didn't need to restart.
If I run a
SELECT @@VERSIONquery, it returns the correct version number. However, if you scroll all the way to the right, it shows (Build 3790: Service Pack 1)
Why is that?
I've also noticed that when I installed service pack 4, the version number increases to 8.00.2039 or whatever it was. That is the correct version number for the service pack. However, at the very end of the returned row of teh query, it still shows up as service pack 1 in text. That is really throwing me off some. I'm guessing the programmer working on the install for SQL service packs didn't really find that in their debugging. Or the text at the end of the query might just be related to something totally different. Anyone know what I'm talk'n about?
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.