Has anyone applied SP3a to SP3? 1

[SQLBill]

Our main database is part of a vendor product. Back when SQL Server SP3 came out, I applied it. When SP3a came out, Microsoft said there was no need to apply it if you have SP3 applied. Now the vendor (who doesn't support SP4 yet) is stating that we need to apply SP3a for their product to work properly.

However, when I run SP3a on the system (which already has SP3), it seems to run fine. But when I do a select to get the version, it still shows 760 (SP3) not 766 (SP3a). If I run SELECT ServerProperty('ProductVersion'), ServerProperty('ProductLevel'), ServerProperty('edition') it shows SP3.

So, my question is - is it possible to apply SP3a to SP3?

-SQLBill

Posting advice: FAQ481-4875

 

[DrSql]

Here is a link that would help you with SP.

http://vyaskn.tripod.com/sqlsps.htm

Dr.Sql
Good Luck.

 

[SQLBill]

Dr.SQL,

Thanks for that information (I already had it though). How does that answer my question?

-SQLBill

Posting advice: FAQ481-4875

 

[DrSql]

Hope this link can calrify you weather you need to install it or not.

http://www.microsoft.com/sql/downloads/2000/sp3.mspx

Dr.Sql
Good Luck.

 

[SQLBill]

I don't need to know whether I need to install it or not. The vendor's product doesn't work properly without it, so I HAVE to install it. My question was: CAN you apply SP3a to SP3? I should add: And will it work?

I've tried applying it already, but the version number doesn't change (it stays 8.00.760).



Posting advice: FAQ481-4875

 

[mrdenny]

I've got servers which also have 3a on them which also show version .760. You should be ok.

A site I found (

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=37)

shows that both sp3 and sp3a will report .760.

I think I installed 3a or an sp3 server a while back without problems but that would have been a couple of years ago. I can't imaging that there is a problem with putting 3a over 3.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[SQLBill]

Thanks to all, I finally found the information I needed on Microsoft's site. Just when you think using @@Version or ServerProperty('ProductVersion'), ServerProperty('ProductLevel') works.....turns out sometimes it doesn't give you the right information......

http://support.microsoft.com/default.aspx?scid=kb;en-us;819334

How to Distinguish Between SQL Server 2000 SP3 and SQL Server 2000 SP3a

To determine whether you have SQL Server 2000 SP3 or SQL Server 2000 SP3a installed, check the version number of the Net-Library file, Ssnetlib.dll. If the version number of this file is 2000.80.760.0, you have SQL Server 2000 SP3. If the version number of this file is 2000.80.766.0, you have SQL Server 2000 SP3a.

Assuming that an instance was installed by using the default settings, you can find the Ssnetlib.dll file in one of these locations: • Default instance: C:\Program Files\Microsoft SQL Server\Binn\Ssnetlib.dll
• Named instance: C:\Program Files\Microsoft SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll

Based on the ssnetlib.dll file, I do have SP3a applied.

-SQLBill

Posting advice: FAQ481-4875

 

[JohnBates]

When I run SELECT @@VERSION I get "8.00.760"

but I know I installed SP3a, and neveinstalled SP3.

John

 

[SQLBill]

That's correct. And if you run:
SELECT ServerProperty('ProductVersion'), ServerProperty('ProductLevel')

You will also get back 760. Microsoft's website shows that both SP3 and SP3a will return 760. HOWEVER, as I said in my previous post, you can tell which one you have installed by checking the ssnetlib.dll file. Right click on it, select properties, and go to the Version tab. That will show 8.00.760 for SP3 and 8.00.766 for SP3a. According to Microsoft, that's really the ONLY way to tell if you have SP3a vice SP3 installed.

-SQLBill

Posting advice: FAQ481-4875

 

[JohnBates]

Thanks SQLBill.

yep, the properties--> version shows 766