bmr270 (9/18/2008)
When I check the version of SQL server in Enterprise ManagerIt is showingProduct version:8.00.2039(SP4)
When I check the version of SQL server in Query analyzer (@@version)
It is showing Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 2)
Thanks,
Bmr
If I am not mistaken - the versions are the same. SQL Server version 8.00.2039 for both QA and EM.
The build information is for the OS - Windows NT 5.2 Service Pack 2.
You can also run the following:
Select serverproperty('ProductVersion')
,serverproperty('ProductLevel');
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs