|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
05/09/2008, 14h32
|
#1 |
Messages: n/a
Hébergeur: |
sp2 install question
I installed SP2 on my SQL server, but when I run the [select @@version] its
still showing SP1, but when I go under [Add/Remove Programs] it has SP2 for SQL 2005 listed. What would cause the SQL server not to show SP2 when I run the [select @@version] query? |
|
|
05/09/2008, 14h36
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: sp2 install question
SELECT @@VERSION do not show service pack level for your SQL Server instance, it only show build
level. The service pack level shown by @@VERSION is your operating system's level. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Mike" <whyyoulookingatme@gmail.com> wrote in message news:%23IcAhN1DJHA.528@TK2MSFTNGP06.phx.gbl... >I installed SP2 on my SQL server, but when I run the [select @@version] its still showing SP1, but >when I go under [Add/Remove Programs] it has SP2 for SQL 2005 listed. What would cause the SQL >server not to show SP2 when I run the [select @@version] query? > > > |
|
|
|
05/09/2008, 14h43
|
#3 |
|
Messages: n/a
Hébergeur: |
Re: sp2 install question
Don't feel bad Mike, I have made this very same mistake - more than once!
:-) -- Kevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote in message news:e3XuVQ1DJHA.4104@TK2MSFTNGP05.phx.gbl... > SELECT @@VERSION do not show service pack level for your SQL Server > instance, it only show build level. The service pack level shown by > @@VERSION is your operating system's level. > > -- > Tibor Karaszi, SQL Server MVP > http://www.karaszi.com/sqlserver/default.asp > http://sqlblog.com/blogs/tibor_karaszi > > > "Mike" <whyyoulookingatme@gmail.com> wrote in message > news:%23IcAhN1DJHA.528@TK2MSFTNGP06.phx.gbl... >>I installed SP2 on my SQL server, but when I run the [select @@version] >>its still showing SP1, but when I go under [Add/Remove Programs] it has >>SP2 for SQL 2005 listed. What would cause the SQL server not to show SP2 >>when I run the [select @@version] query? >> >> >> > |
|
|
|
05/09/2008, 14h46
|
#4 |
|
Messages: n/a
Hébergeur: |
Re: sp2 install question
I found that this
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') will show you what SP your running. "TheSQLGuru" <kgboles@earthlink.net> wrote in message news:A5adnfkdTcWptFzVnZ2dnUVZ_rzinZ2d@earthlink.co m... > Don't feel bad Mike, I have made this very same mistake - more than once! > :-) > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote > in message news:e3XuVQ1DJHA.4104@TK2MSFTNGP05.phx.gbl... >> SELECT @@VERSION do not show service pack level for your SQL Server >> instance, it only show build level. The service pack level shown by >> @@VERSION is your operating system's level. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Mike" <whyyoulookingatme@gmail.com> wrote in message >> news:%23IcAhN1DJHA.528@TK2MSFTNGP06.phx.gbl... >>>I installed SP2 on my SQL server, but when I run the [select @@version] >>>its still showing SP1, but when I go under [Add/Remove Programs] it has >>>SP2 for SQL 2005 listed. What would cause the SQL server not to show SP2 >>>when I run the [select @@version] query? >>> >>> >>> >> > > |
|
|
|
05/09/2008, 14h47
|
#5 |
|
Messages: n/a
Hébergeur: |
Re: sp2 install question
To add to Tibor and SQLGurus post use SERVERPROPERTY function
select SERVERPROPERTY ('ProductLevel') -- vinu http://oneplace4sql.blogspot.com/ "TheSQLGuru" <kgboles@earthlink.net> wrote in message news:A5adnfkdTcWptFzVnZ2dnUVZ_rzinZ2d@earthlink.co m... > Don't feel bad Mike, I have made this very same mistake - more than once! > :-) > > -- > Kevin G. Boles > Indicium Resources, Inc. > SQL Server MVP > kgboles a earthlink dt net > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.co m> wrote > in message news:e3XuVQ1DJHA.4104@TK2MSFTNGP05.phx.gbl... >> SELECT @@VERSION do not show service pack level for your SQL Server >> instance, it only show build level. The service pack level shown by >> @@VERSION is your operating system's level. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://sqlblog.com/blogs/tibor_karaszi >> >> >> "Mike" <whyyoulookingatme@gmail.com> wrote in message >> news:%23IcAhN1DJHA.528@TK2MSFTNGP06.phx.gbl... >>>I installed SP2 on my SQL server, but when I run the [select @@version] >>>its still showing SP1, but when I go under [Add/Remove Programs] it has >>>SP2 for SQL 2005 listed. What would cause the SQL server not to show SP2 >>>when I run the [select @@version] query? >>> >>> >>> >> > > |
|
|
|
05/09/2008, 15h26
|
#6 |
|
Messages: n/a
Hébergeur: |
Re: sp2 install question
On Sep 5, 5:32 pm, "Mike" <whyyoulookinga...@gmail.com> wrote:
> I installed SP2 on my SQL server, but when I run the [select @@version] its > still showing SP1, but when I go under [Add/Remove Programs] it has SP2 for > SQL 2005 listed. What would cause the SQL server not to show SP2 when I run > the [select @@version] query? Look at serverproperty function at BOL Amish Shah http://shahamishm.blogspot.com |
|
|
 |
| Outils de la discussion | |
|
|
