Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America asked on

SQL Server 2008 Service Pack 3

How can I find out if SQL Server 2008 Service Pack 3 is installed in my computer?

I have SQL Server 2008 R2, so should I be looking for SQL Server 2008 R2 Service Pack 3 to download and install?

What should I be watching to make sure the installation is successful?

Thank you.
Microsoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment
Mike Eghtebas

8/22/2022 - Mon
Aneesh

run this,
SELECT SERVERPROPERTY('ProductLevel')
ASKER
Mike Eghtebas

It returns RTM; what does it mean? It should have said SP3 if I had it?

Mike
Aneesh

You don't have any of the SPs installed and you can install SP3
It should have said SP3 if I had it?
correct
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
Mike Eghtebas

re:> You don't have any of the SPs installed...

How many are there to be installed. If more than one, does the order I install matters?

Also, what TRM stands for?

Thank you,

Mike
Aneesh

RTM ->release to manufacturing
You just need to install the latest SP, SP3 includes all the patches since SP1, so you don't have to install SP1 or SP2.
ASKER
Mike Eghtebas

Thank you for the info. Is there anything particular I need to watch for? Such as to go with 86 or 64. In some cases, although the computer may be 86; but you have to go with 64 or some other depending on the application. Other than this, any other hurdle I could come across to it?

Thank you.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mike Eghtebas

Sorry, but how do I find what I have (86 or 64)? I could find any info in About form.

As I mentioned earlier, I have 2008 R2, would that by default be 86?
Aneesh

Run
SELECT @@Version

it will show the version, for 64 bit it will be like this

Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
      Jun 17 2011 00:54:03
      Copyright (c) Microsoft Corporation
      Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
ASKER
Mike Eghtebas

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy