how to find out the SP version?

Is there any convinient way to find out the service pack version on SQL
Server 2000?
select @.@.version revelas info about the OS SP version, but not about the SQL
Server SP version.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)
8.00.194 no sp
8.00.384 sp1
8.00.532 sp2
8.00.760 sp3
8.00.818 Sp3 with cumulative patch 03-031
8.00.2039 Sp4
"Magnus sterberg" <magnus.osterberg@.abo.fi> wrote in message
news:dg9abt$kv3$1@.plaza.suomi.net...
> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the
> SQL Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>
|||HOW TO: identify your SQL Server Service Pack version and edition
http://support.microsoft.com/default...b;en-us;321185
AMB
"Magnus ?sterberg" wrote:

> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the SQL
> Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>
|||Hi Magnus
A fuller list of version number can be found at
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 or
http://www.aspfaq.com/sql2000builds.asp
John
"Magnus sterberg" <magnus.osterberg@.abo.fi> wrote in message
news:dg9abt$kv3$1@.plaza.suomi.net...
> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the
> SQL Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>

how to find out the SP version?

Is there any convinient way to find out the service pack version on SQL
Server 2000?
select @.@.version revelas info about the OS SP version, but not about the SQL
Server SP version.
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
NT 5.2 (Build 3790: Service Pack 1)8.00.194 no sp
8.00.384 sp1
8.00.532 sp2
8.00.760 sp3
8.00.818 Sp3 with cumulative patch 03-031
8.00.2039 Sp4
"Magnus sterberg" <magnus.osterberg@.abo.fi> wrote in message
news:dg9abt$kv3$1@.plaza.suomi.net...
> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the
> SQL Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>|||HOW TO: identify your SQL Server Service Pack version and edition
http://support.microsoft.com/defaul...kb;en-us;321185
AMB
"Magnus ?sterberg" wrote:

> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the S
QL
> Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>|||Hi Magnus
A fuller list of version number can be found at
http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37 or
http://www.aspfaq.com/sql2000builds.asp
John
"Magnus sterberg" <magnus.osterberg@.abo.fi> wrote in message
news:dg9abt$kv3$1@.plaza.suomi.net...
> Is there any convinient way to find out the service pack version on SQL
> Server 2000?
> select @.@.version revelas info about the OS SP version, but not about the
> SQL Server SP version.
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows
> NT 5.2 (Build 3790: Service Pack 1)
>
>