Re: Installing the correct SQL Server Patch
From: BP Margolin (bpmargo_at_attglobal.net)
Date: 05/06/03
- Next message: Richard Walker: "Changing authentication mode"
- Previous message: Dan Guzman: "Re: Installing the correct SQL Server Patch"
- In reply to: Denise: "Installing the correct SQL Server Patch"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 5 May 2003 22:16:11 -0400
Denise,
To determine your current SQL Server 2000 service pack level:
select serverproperty('ProductLevel')
Each new SQL Server service pack contains all the fixes in all the earlier service packs, so one need only apply the latest service pack ... in the case of SQL Server 2000, that's service pack 3.
You can get SP3 from: http://www.microsoft.com/sql/downloads/2000/sp3.asp
-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.
"Denise" <daugusti@cox.net> wrote in message news:044a01c31369$36e92a10$a301280a@phx.gbl...
> Hi,
> I am a novice. How do you find the Version number and/or
> know which SQL SErver Patch to download and install on my
> machine.
> I have Windows XP.
> I do not know whether I need:
> .. SQL Server 2000?
> .. SQL Server 2000 Service Pack 1?
> .. SQL Server 2000 Service Pack 2?
> .. SQL Server (re-patch)?
>
> I keep getting nasty abuse messages from my ISP regarding
> the W32.SQLExp.Worm. I have downloaded the --Removal Tool-
> - and now I need to install a new patch.
>
> Thanks
> Denise
- Next message: Richard Walker: "Changing authentication mode"
- Previous message: Dan Guzman: "Re: Installing the correct SQL Server Patch"
- In reply to: Denise: "Installing the correct SQL Server Patch"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
