SQL Service Packs - What is going on?

[1DMF]

Can someone help confirm if the problem I have is due to no service packs. I seem to have this issue....

http://support.microsoft.com/kb/306199

So I have gone to query analyser and ran

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

According to this knowledge base

http://support.microsoft.com/kb/321185

, the results I get are

8.00.194 RTM Standard Edition

Which seems to indicate I am running SQL 2000 straight out the box with no service packs, however, when I run windows update, it doesn't offer me any service packs for SQL 2000?

The only service pack on offer is SP2 for SQL 2008 but we already have SP2 SQL 2K8 installed.

I'm very confused, are service packs applied to each instance rather than generically to all SQL instances?

Your help is appreciated.

Regards,
1DMF.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[gmmastros]

Are service packs applied to each instance rather than generically to all SQL instances?

Yes.

If you have multiple instances, you should install the service packs on all of them.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[1DMF]

So basically I need to re-install SP4 because of the idiot who dialled into the server, corrupted our SQL and re-created a new instance didn't apply any SP's?

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[gmmastros]

Well.... the idiot that dialed in to your server and messed things up was NOT me, so I am comfortable saying, "Yes".

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[1DMF]

- many thanks, I just want to be sure i'm doing the right thing, this has been a nightmare for me and the company, the last thing I want to do is cock things up even more.

I'll let you know how I get on and if I need to aportion any of the blame your way

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

Well the SP4 installed OK , but it hasn't resolved the problem.

I'm running out of hair!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts