Service Pack 3 - Newbie

[jdavis37]

I'm new to sql 2000. I just didn't an installation. I want to apply the lastest service pack. which one should i install? sql2kasp3.exe, sql2desksp3.exe or sql2sp3.exe. I install this on a 2000 server. thanks

 

[JayKusch]

SP3A

Thanks

J. Kusch

 

[mrdenny]

sql2sp3.exe is the service pack for the Server.
sql2kasp3.exe is the service pack for the analyse tools.
sql2desksp3.exe is the service pack for the desktop edition.

You want sql2sp3.exe. Be use that you use sp3a not sp3. There are some fixes in 3a that arn't in 3.

Denny Cherry

 

[jdavis37]

thanks! After I install the service pack. How can I verify if I have the lastest installed. I tried the following,
net start mssqlserver
osql -usa -p

I received the prompt...1> but when I typed select @@version. I received nothing.

jd

 

[mrdenny]

Query Analyzer is an easier tool to use. You should find it under Start/Programs/Microsoft SQL Server/

If you want to use osql add the -c switch. This allows you to use a character to tell osql that you are at the end of the command. Try using "osql -u sa -p -c ;".

Then run:

SELECT 'SQL Server '
+ CAST(SERVERPROPERTY('productversion') AS VARCHAR) + ' - '
+ CAST(SERVERPROPERTY('productlevel') AS VARCHAR) + ' ('
+ CAST(SERVERPROPERTY('edition') AS VARCHAR) + ')'

The server I'm logged into at the member returns "SQL Server 8.00.818 - SP3 (Enterprise Edition)".

Denny Cherry