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.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Aneesh RetnakaranDatabase AdministratorCommented:
run this,
SELECT SERVERPROPERTY('ProductLevel')
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
It returns RTM; what does it mean? It should have said SP3 if I had it?

Mike
0
Aneesh RetnakaranDatabase AdministratorCommented:
You don't have any of the SPs installed and you can install SP3
It should have said SP3 if I had it?
correct
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
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
0
Aneesh RetnakaranDatabase AdministratorCommented:
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.
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
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.
0
Aneesh RetnakaranDatabase AdministratorCommented:
if you have SQL 64 bit , go with the 64bit service pack, otherwise x86 Service pack
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
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?
0
Aneesh RetnakaranDatabase AdministratorCommented:
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)
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.