July 6, 2005 at 1:07 pm
Hi,
After applying SP4 (with errors), I ran SELECT serverproperty('EngineEdition'), serverproperty('ProductLevel'), serverproperty('ProductVersion') command. Now I see that
3 SP4 8.00.2039
Does this mean that I have SP4 on the box.
Thanks,
R
July 6, 2005 at 1:30 pm
8.00.2039 is the SQL Server version for SP4, yes. If you see that it should mean you have SP4 applied to your SQL Server.
K. Brian Kelley
@kbriankelley
July 7, 2005 at 8:16 am
Thank you Brian.
July 7, 2005 at 9:18 am
Here's a hand link for future reference:
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185#2
I've always had this one as an Internet shortcut !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
July 7, 2005 at 9:26 am
This is the one I usually refer to since it also lists version changes due to hotfixes:
SQL Security: SQL Server Version Database
K. Brian Kelley
@kbriankelley
July 8, 2005 at 8:41 am
You can even check by right click on properties of that particular instance under Enterprise Manager. It should be showing :
Product Version : 8.00.2039(SP4)
--Kishore
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply