Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2009-04-28 : 04:58:31
|
| Hi AllFirstly Thanks for looking at this post......I need to identify what service pack my SQL server is running i ran the following code....SELECTSERVERPROPERTY('Edition') AS [Edition],SERVERPROPERTY('ProductVersion') AS [Product Version],SERVERPROPERTY('ProductLevel') AS [Product Level]it outputed.....Edition Product Version Product LevelStandard Edition (64-bit) 9.00.1399.06 RTMWhat service pack is it running???Kind Regards Pete.Kind RegardsPete. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2009-04-28 : 05:06:03
|
| sorry in addition....I have four instances on the same SQL box, If i need to install a service pack will be rolled out to each instance.....excuse my ignorance.....PeteKind RegardsPete. |
 |
|
|
Stamey
Starting Member
14 Posts |
Posted - 2009-04-28 : 09:40:24
|
| The service pack install will install to whatever instances you tell it to. It will identify the various instances at the beginning of the install and ask you which ones to install on. It will upgrade the "common tools" if you install the SP on any instance, regardless of whther you install the SP on some or all of the other instances.The 1399.06 part of your version tells you what SP you have, using the list thaqt khtan mentioned. Trust only that number since there have been know to be multiple releases of the same SP, with no difference besides the bugs fixed and the build number.Chris |
|
|
|
|
|
|
How to identify service pack on SQL 2005