Check the version of Service pack

How do I check the version of service pack installed to my
sql server...
I tried Select @.@.version
I tried select serverproperty('productlevel')
I get sp3 on the later and now I installed sp3a
still the output of select serverproperty('productlevel')
gives sp3
Please help
Thanks
Alka
Alka,
SERVERPROPERTY is returning SP3 because all the changes in SP3a are setup
related and there are no changes in the database engine.Heres a snippet from
SP3a readme file:
How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a
To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a
installed, check the version number of the Net-Library file, Ssnetlib.dll.
If the version number of this file is 2000.80.760.0, you have SQL Server
2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL
Server 2000 SP3a.
Assuming that an instance was installed by using the default settings, you
can find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft SQL
Server\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Alka,
The build of SQL did not change from SP3 to SP3A. Check that ssnetlib.dll is
now version 2000.80.766.0 then you have SP3A. If it is 2000.80.760.0 you
have SP3.
Chris Wood
Alberta Department of Energy
CANADA
"Alka Srivaastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
> How do I check the version of service pack installed to my
> sql server...
> I tried Select @.@.version
> I tried select serverproperty('productlevel')
> I get sp3 on the later and now I installed sp3a
> still the output of select serverproperty('productlevel')
> gives sp3
> Please help
> Thanks
> Alka
|||Thanks Dinesh
But my file shows version 2000.80.818.0
Please help...
Thanks
Alka
>--Original Message--
>Alka,
>SERVERPROPERTY is returning SP3 because all the changes
in SP3a are setup
>related and there are no changes in the database
engine.Heres a snippet from
>SP3a readme file:
>How to Distinguish Between SQL Server 2000 SP3 and SQL
Server 2000 SP3a
>To determine whether you have SQL Server 2000 SP3 or SQL
Server 2000 SP3a
>installed, check the version number of the Net-Library
file, Ssnetlib.dll.
>If the version number of this file is 2000.80.760.0, you
have SQL Server
>2000 SP3. If the version number of this file is
2000.80.766.0, you have SQL
>Server 2000 SP3a.
>Assuming that an instance was installed by using the
default settings, you
>can find the Ssnetlib.dll file in one of these locations:
> a.. Default instance: C:\Program Files\Microsoft SQL
>Server\Binn\Ssnetlib.dll
> b.. Named instance: C:\Program Files\Microsoft
>SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dl l
>
>--
>Dinesh
>SQL Server MVP
>--
>--
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Alka Srivaastava" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:1d1f101c42320$fec140a0$a301280a@.phx.gbl...
my[vbcol=seagreen]
('productlevel')
>
>.
>
|||Alka,
May be some hotfix(http://support.microsoft.com/?kbid=821688). Can you check
the registry entry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ Hotfixes\ ?If its a
hotfix, an entry will be made at this key.BTW, what is the output of select
@.@.version?
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"Alka Srivastava" <anonymous@.discussions.microsoft.com> wrote in message
news:1a5a401c42325$926b1570$a601280a@.phx.gbl...[vbcol=seagreen]
> Thanks Dinesh
> But my file shows version 2000.80.818.0
> Please help...
> Thanks
> Alka
> in SP3a are setup
> engine.Heres a snippet from
> Server 2000 SP3a
> Server 2000 SP3a
> file, Ssnetlib.dll.
> have SQL Server
> 2000.80.766.0, you have SQL
> default settings, you
> wrote in message
> my
> ('productlevel')