|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
09/07/2007, 18h18
|
#1 |
Messages: n/a
Hébergeur: |
SQL SP's
Hi can someone tell me how I can see which evrsion of SQL I have installed
and what service pack is installed thanks A |
|
|
09/07/2007, 19h22
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: SQL SP's
Alex,
It is the build number found in: xp_msver --or-- SELECT @@VERSION Here is Steve Jones' list of RTM through SP2 build numbers. http://www.sqlservercentral.com/colu...jones/2960.asp RLF "Alex" <aph@hotmail.co.uk> wrote in message news:OAqBm0kwHHA.4132@TK2MSFTNGP02.phx.gbl... > Hi can someone tell me how I can see which evrsion of SQL I have installed > and what service pack is installed > > thanks > A > > |
|
|
|
10/07/2007, 21h57
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: SQL SP's
For a more comprehensive answer including the service pack, try
SELECT serverproperty('ProductVersion') AS Version, serverproperty('ProductLevel') AS ServicePack, serverproperty('Edition') AS Edition -- Rick Byham (MSFT) This posting is provided "AS IS" with no warranties, and confers no rights. "Russell Fields" <russellfields@nomail.com> wrote in message news:uhRcgYlwHHA.4612@TK2MSFTNGP04.phx.gbl... > Alex, > > It is the build number found in: > > xp_msver > --or-- > SELECT @@VERSION > > Here is Steve Jones' list of RTM through SP2 build numbers. > http://www.sqlservercentral.com/colu...jones/2960.asp > > RLF > > "Alex" <aph@hotmail.co.uk> wrote in message > news:OAqBm0kwHHA.4132@TK2MSFTNGP02.phx.gbl... >> Hi can someone tell me how I can see which evrsion of SQL I have >> installed and what service pack is installed >> >> thanks >> A >> >> > > |
|
|
 |
| Outils de la discussion | |
|
|
