July 18, 2004 at 8:54 am
I have 3 SQL Server (Win 2K SP4 SQLSvr 2000 SP3). When I run select @@version it tells me the server has SP4 on all three. When I run sp_server_info 2 of them say I am running SP3 the other says I am running SP4 which is corrrect. I have reinstalled W2K SP4 and I get the same result, Microsoft SQL Server 2000 - 8.00.534 (Intel X86) Nov 19 2001 13:23:50 Copyright (c) 1988-2000 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3) , Is this a problem I should be concerned about? Has anybody else ran into this?
Thanks
July 18, 2004 at 11:03 am
@@version tells you both the operating system patch level and the sql server patch level.
The sql server build level is displayed as a number e.g. 8.00.760 for SP3/3A
An updated list of the build numbers can be found at
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37
Steven
July 19, 2004 at 5:28 am
As does sp_server_info. My problem is @@version returns SP4 as the service pack for the OS and sp_server_info returns SP3. My question is is this a problem that I should be concerned about? They both return the correct SP for SQL Server.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply