I have Windows 2000 Advanced Server with SQL Server 2000
with SP3A in a Active\Active Cluster.

When I loaded Windows 2000 SP4 on the server it changed
SQL Server 2000 version to "Microsoft SQL Server 2000 -
8.00.194 (Intel X86)".

If the Active (Node A)\ Active (Node B) cluster was moved
from original location could this change the SQL Server
version number. (Move Node A to Node B)


What could cause the version number to change within SQL
Server 2000. If the version is wrong is there away to
determine the version by SQL Server file dates?


Please help me resolve this issue.

Thanks,

Mark

weird normally the best way is to type the query below in Query Analyzer
which is determined by the version of SQLServr.exe.

SELECT @@VERSION

http://support.microsoft.com/default...b;en-us;321185

Although ocasionally (as with build 819 from
http://support.microsoft.com/default...b;en-us;826161) the real
version is not reflected as SQLServr.exe is not updated. In this case check
the registry @ HKLM\SOFTWARE\Microsoft\MSSQLServer\Hotfixes\0819

regards,
Andy.
"Mark" <anonymous (AT) discussions (DOT) microsoft.com> wrote