Reporting Services Service Pack 2

Ok,
How do I get what Service Pack if any is installed for Reporting Services?
Version?
SQL query?
I see there is a Service Pack 2 for Reporting Services. Should everything be
fine with my reports after I
install this or is this going to be a mess? Break everything?
thanks
gvThere is no service pack 2 for RS 2005. RS 2000 does have it and is good, I
ran in production with that for quite awhile. For RS 2005 if you install SP1
then you also need to get a hotfix because SP1 broke using All for
multi-select parameters. SP2 is out as a pre-release. I have not installed
it however.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gv" <viator.gerry@.gmail.com> wrote in message
news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
> Ok,
> How do I get what Service Pack if any is installed for Reporting Services?
> Version?
> SQL query?
> I see there is a Service Pack 2 for Reporting Services. Should everything
> be fine with my reports after I
> install this or is this going to be a mess? Break everything?
> thanks
> gv
>|||We are running SQL 2000 Report Services.
How do I check Version Information? What has been installed
thanks for your help
gv
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
> There is no service pack 2 for RS 2005. RS 2000 does have it and is good,
> I ran in production with that for quite awhile. For RS 2005 if you install
> SP1 then you also need to get a hotfix because SP1 broke using All for
> multi-select parameters. SP2 is out as a pre-release. I have not installed
> it however.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "gv" <viator.gerry@.gmail.com> wrote in message
> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should everything
>> be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>|||http://servername/Reportserver will show you the Version of the Reporting
service:
original installation 8.00.743.00
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"gv" <viator.gerry@.gmail.com> wrote in message
news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
> We are running SQL 2000 Report Services.
> How do I check Version Information? What has been installed
> thanks for your help
> gv
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is good,
>> I ran in production with that for quite awhile. For RS 2005 if you
>> install SP1 then you also need to get a hotfix because SP1 broke using
>> All for multi-select parameters. SP2 is out as a pre-release. I have not
>> installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>|||ok great!
I'm running SP2 - 8.00.1038.00
thanks for your help
gv
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e%237Y1ICBHHA.1196@.TK2MSFTNGP02.phx.gbl...
> http://servername/Reportserver will show you the Version of the Reporting
> service:
> original installation 8.00.743.00
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "gv" <viator.gerry@.gmail.com> wrote in message
> news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
>> We are running SQL 2000 Report Services.
>> How do I check Version Information? What has been installed
>> thanks for your help
>> gv
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is
>> good, I ran in production with that for quite awhile. For RS 2005 if you
>> install SP1 then you also need to get a hotfix because SP1 broke using
>> All for multi-select parameters. SP2 is out as a pre-release. I have not
>> installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>>
>|||Another easy way of figuring out if you have SP 2 to RS 2000, is to see if
there's a printer icon on the toolbar of a report that has been rendered. No
printer icon = no SP 2. Printer icon = SP2.
Kaisa M. Lindahl Lervik
"gv" <viator.gerry@.gmail.com> wrote in message
news:eHAz1MCBHHA.996@.TK2MSFTNGP02.phx.gbl...
> ok great!
> I'm running SP2 - 8.00.1038.00
> thanks for your help
> gv
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e%237Y1ICBHHA.1196@.TK2MSFTNGP02.phx.gbl...
>> http://servername/Reportserver will show you the Version of the Reporting
>> service:
>> original installation 8.00.743.00
>> SP1 is Version 8.00.878.00
>> SP2 is Version 8.00.1038.00
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:uEryG5BBHHA.3560@.TK2MSFTNGP04.phx.gbl...
>> We are running SQL 2000 Report Services.
>> How do I check Version Information? What has been installed
>> thanks for your help
>> gv
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:uwG5U1BBHHA.1780@.TK2MSFTNGP03.phx.gbl...
>> There is no service pack 2 for RS 2005. RS 2000 does have it and is
>> good, I ran in production with that for quite awhile. For RS 2005 if
>> you install SP1 then you also need to get a hotfix because SP1 broke
>> using All for multi-select parameters. SP2 is out as a pre-release. I
>> have not installed it however.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "gv" <viator.gerry@.gmail.com> wrote in message
>> news:%23OkTFkBBHHA.3368@.TK2MSFTNGP03.phx.gbl...
>> Ok,
>> How do I get what Service Pack if any is installed for Reporting
>> Services? Version?
>> SQL query?
>> I see there is a Service Pack 2 for Reporting Services. Should
>> everything be fine with my reports after I
>> install this or is this going to be a mess? Break everything?
>> thanks
>> gv
>>
>>
>>
>