Conflicting server versions
-
I am a new user to the group and I found that this is an excellent forum with lots of relevant information. Here is my question, I have a SQL Server and I am trying to identify its version. I ran these two queries.
select attribute_value from master.dbo.spt_server_info where Attribute_ID = 2
go
select @@version
go
Here is what I got:
attribute_value
----------------------------------------------------
Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
----------------------------------------------------
Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
I would expect them to be the same. Why would they be different? Has anyone had anyhting like this before?
thanks.
-
This was removed by the editor as SPAM
-
Steve-
I applied SP3a on my machine and then checked the @@verion. It still shows 8.00.384 I looked at the help in QA and it shows 8.00.760.
I checked sp_server_info and it returns 8.00.760. Then I was surfing the web and came across this article. You were recommending @@Version. But in my case, looks like sp_server_info was returning the correct version.
-
I spoke with NGSSoftware about this also and we never could conclusively figure it completely out.
sorry
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
while this is real old now, the versions are due to hotfixes, this site was a help to us.
http://www.krell-software.com/mssql-builds.htm
hope this can still help.
part of the confusion is MS method of having weak hot-fixes, then they yank them from the web and replace with new or SP and references to original patches become vapor. we archive all patches with documentation as they are applied these days.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply