944,209 Members | Top Members by Rank

Web Development > Databases > MS SQL > SQL 2000 Service Pack 3a Installation Problems
Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 3728
  • MS SQL RSS
Permalink
May 3rd, 2006
0

SQL 2000 Service Pack 3a Installation Problems

Expand Post »
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.
Similar Threads
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004
Permalink
May 4th, 2006
0

Re: SQL 2000 Service Pack 3a Installation Problems

You probably need to restart :-|
Reputation Points: 48
Solved Threads: 7
Posting Whiz
aniseed is offline Offline
353 posts
since Apr 2006
Permalink
May 4th, 2006
0

Re: SQL 2000 Service Pack 3a Installation Problems

Quote 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
MS SQL Syntax (Toggle Plain Text)
  1. 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?
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004
Permalink
May 5th, 2006
0

Re: SQL 2000 Service Pack 3a Installation Problems

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?
Reputation Points: 12
Solved Threads: 6
Junior Poster
Geek-Master is offline Offline
156 posts
since Dec 2004

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: SQLServer 2000 Scheduled Job recurring every second
Next Thread in MS SQL Forum Timeline: In-line If-Else Block?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC