Link to home
Start Free TrialLog in
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.
Avatar of Aneesh
Aneesh
Flag of Canada image

run this,
SELECT SERVERPROPERTY('ProductLevel')
Avatar of Mike Eghtebas

ASKER

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

Mike
You don't have any of the SPs installed and you can install SP3
It should have said SP3 if I had it?
correct
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
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.
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.
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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?
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)