|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
23/10/2007, 22h28
|
#1 |
Messages: n/a
Hébergeur: |
how to tell if SP2 installed ?
How to tell if an instance has SP2 ?
My instance is version 9.00.3054.00 |
|
|
23/10/2007, 23h09
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: how to tell if SP2 installed ?
John,
Then you have SP2 with a couple of hot fixes. Your version is defined in this post: http://blogs.msdn.com/psssql/archive...explained.aspx For more recent fixes, see also: http://support.microsoft.com/kb/937137/LN/ RLF "John A Grandy" <johnagrandy@gmail.com> wrote in message news:uCwTdubFIHA.284@TK2MSFTNGP02.phx.gbl... > How to tell if an instance has SP2 ? > > My instance is version 9.00.3054.00 > |
|
|
|
24/10/2007, 09h16
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: how to tell if SP2 installed ?
Run the following code in Query Editor, it'll tell you if SP2 of SQL Server
is installed. select serverproperty('ProductLevel') -- Ekrem Önsoy http://www.ekremonsoy.net , http://ekremonsoy.blogspot.com MCBDA, MCTS: SQL Server 2005, MCITP  BA, MCSD.Net, MCSE, MCT"John A Grandy" <johnagrandy@gmail.com> wrote in message news:uCwTdubFIHA.284@TK2MSFTNGP02.phx.gbl... > How to tell if an instance has SP2 ? > > My instance is version 9.00.3054.00 > |
|
|
|
| Outils de la discussion | |
|
|
