Re: Do I have sp3a o sp3 installed on my SQL 2000?
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 02/05/04
- Next message: Ward Horsfall: "Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Previous message: Tibor Karaszi: "Re: SQL setting from case sensitive to case insensitive"
- In reply to: Vishal Parkar: "Re: Do I have sp3a o sp3 installed on my SQL 2000?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 5 Feb 2004 13:52:00 -0000
It's C:\Program Files\Microsoft SQL Server\MSSQL\Binn\ for the default
installation of the default instance; that's a mistake in the SP3a readme
file.
-- Jacco Schalkwijk SQL Server MVP "Vishal Parkar" <REMOVE_THIS_vgparkar@yahoo.co.in> wrote in message news:uG3crw26DHA.1716@TK2MSFTNGP10.phx.gbl... > hi Ivan, > > To determine whether you have SP3 or SP3a installed, you will have to look at > the version number of the net library file (ssnetlib.dll). located at location: > > C:\Program Files\Microsoft SQL Server\Binn\ > OR (for named instance) > C:\Program Files\Microsoft SQL Server\MSSQL$<instance_name>\Binn\ > > Right click on this file, go to the "version" tab. If the version of this file > is 2000.80.760.0, then SP3 is installed > if the version of this file is 2000.80.766.0, then SP3a is installed. > > > -- Vishal > >
- Next message: Ward Horsfall: "Installing SQL_Latin1_General_CP1_CI_AS collation order??"
- Previous message: Tibor Karaszi: "Re: SQL setting from case sensitive to case insensitive"
- In reply to: Vishal Parkar: "Re: Do I have sp3a o sp3 installed on my SQL 2000?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
