How do I find out what version of SQL Server 2000 I'm running?

How do I find out what version of SQL Server 2000 I'm running?
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad