MS SQL

SQL 2000 Service Pack 3a Installation Problems

Please support our MS SQL advertiser: Intel Parallel Studio Home

•

Join Date: Dec 2004

Posts: 149

Reputation: Geek-Master is an unknown quantity at this point

Solved Threads: 6

Geek-Master Geek-Master is offline

Offline

Junior Poster

SQL 2000 Service Pack 3a Installation Problems

May 3rd, 2006

I ran the SP3a installation and it didn't return any errors along the way. However, when I ran the query to look at the current version of SQL it still has the service pack at version 1.

Any idea why?

P.S.
I think the installation process is asinine.

If in doubt, reach into the trash can and remove the user guide.

•

Join Date: Apr 2006

Posts: 353

Reputation: aniseed is an unknown quantity at this point

Solved Threads: 6

aniseed

Offline

Posting Whiz

Re: SQL 2000 Service Pack 3a Installation Problems

May 4th, 2006

You probably need to restart :-|

Javascript is not Java

•

Join Date: Dec 2004

Posts: 149

Reputation: Geek-Master is an unknown quantity at this point

Solved Threads: 6

Geek-Master Geek-Master is offline

Offline

Junior Poster

Re: SQL 2000 Service Pack 3a Installation Problems

May 4th, 2006

•

Originally Posted by aniseed

You probably need to restart :-|

I took my SQL Server offline and didn't need to restart.

If I run a

Help with Code Tags

MS SQL Syntax (Toggle Plain Text)

SELECT @@VERSION

query, it returns the correct version number. However, if you scroll all the way to the right, it shows (Build 3790: Service Pack 1)

Why is that?

If in doubt, reach into the trash can and remove the user guide.

•

Join Date: Dec 2004

Posts: 149

Reputation: Geek-Master is an unknown quantity at this point

Solved Threads: 6

Geek-Master Geek-Master is offline

Offline

Junior Poster

Re: SQL 2000 Service Pack 3a Installation Problems

May 5th, 2006

I've also noticed that when I installed service pack 4, the version number increases to 8.00.2039 or whatever it was. That is the correct version number for the service pack. However, at the very end of the returned row of teh query, it still shows up as service pack 1 in text. That is really throwing me off some. I'm guessing the programmer working on the install for SQL service packs didn't really find that in their debugging. Or the text at the end of the query might just be related to something totally different. Anyone know what I'm talk'n about?

If in doubt, reach into the trash can and remove the user guide.