Does SP2 need to be installed on both development clients and serv

Does SP2 need to be installed on both the development clients and the server?
We have many development installs. If the SP changes are significant only
to the server then installing it there only would be much more effective for
us.
ThanksHere's the scoop (which is different than I initially thought, I thought you
did need to upgrade development but I guess it is optional):
>>>>>>
>clip
You don't absolutely need the service pack on your dev box as the schema
hasn't
changed and the designer didn't get too many fixes.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
>>>>>>
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
for
> us.
> Thanks|||The changes are 95% on the server, not on the designer. The designer changes
were a couple of minor fixes. There were no schema changes in RDL so you
should be fine.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
> server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
> for
> us.
> Thanks|||The changes are 95% on the server, not on the designer. The designer changes
were a couple of minor fixes. There were no schema changes in RDL so you
should be fine.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> Does SP2 need to be installed on both the development clients and the
> server?
> We have many development installs. If the SP changes are significant only
> to the server then installing it there only would be much more effective
> for
> us.
> Thanks|||Note: if you don't upgrade the report designer to SP2, the report designer
PREVIEW will still generate the report output based on SP1, because it is
running the report locally and not on the server!
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OReYoWmSFHA.2784@.TK2MSFTNGP12.phx.gbl...
> Here's the scoop (which is different than I initially thought, I thought
> you
> did need to upgrade development but I guess it is optional):
>>>>>>
>>clip
> You don't absolutely need the service pack on your dev box as the schema
> hasn't
> changed and the designer didn't get too many fixes.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
>>>>>>
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> Does SP2 need to be installed on both the development clients and the
> server?
>> We have many development installs. If the SP changes are significant
>> only
>> to the server then installing it there only would be much more effective
> for
>> us.
>> Thanks
>|||Brian,
What were the specific fixes to the Designer? We've seen some intermittent
problems with exporting to Excel from Preview in Designer. If the fixes
relate to that general area, that might further influence our decision.
"Brian Welcker [MS]" wrote:
> The changes are 95% on the server, not on the designer. The designer changes
> were a couple of minor fixes. There were no schema changes in RDL so you
> should be fine.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
> > Does SP2 need to be installed on both the development clients and the
> > server?
> > We have many development installs. If the SP changes are significant only
> > to the server then installing it there only would be much more effective
> > for
> > us.
> > Thanks
>
>|||Note: if you don't upgrade the report designer to SP2, the report designer
Preview will still generate the report output based on SP1 (or RTM), because
it is running the report locally and not on the server!
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:10FDA0EC-88CB-4898-996F-04879B94657A@.microsoft.com...
> Brian,
> What were the specific fixes to the Designer? We've seen some
> intermittent
> problems with exporting to Excel from Preview in Designer. If the fixes
> relate to that general area, that might further influence our decision.
> "Brian Welcker [MS]" wrote:
>> The changes are 95% on the server, not on the designer. The designer
>> changes
>> were a couple of minor fixes. There were no schema changes in RDL so you
>> should be fine.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
>> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> > Does SP2 need to be installed on both the development clients and the
>> > server?
>> > We have many development installs. If the SP changes are significant
>> > only
>> > to the server then installing it there only would be much more
>> > effective
>> > for
>> > us.
>> > Thanks
>>
>>|||The report processing and rendering engine used in preview is the same that
is on the server. So, yes, there were several fixes in this area. Some are
listed in the KB article and some are not.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
news:10FDA0EC-88CB-4898-996F-04879B94657A@.microsoft.com...
> Brian,
> What were the specific fixes to the Designer? We've seen some
> intermittent
> problems with exporting to Excel from Preview in Designer. If the fixes
> relate to that general area, that might further influence our decision.
> "Brian Welcker [MS]" wrote:
>> The changes are 95% on the server, not on the designer. The designer
>> changes
>> were a couple of minor fixes. There were no schema changes in RDL so you
>> should be fine.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "toolman_2000" <toolman2000@.discussions.microsoft.com> wrote in message
>> news:C47B4761-FF95-45CF-AE1A-12911635A11D@.microsoft.com...
>> > Does SP2 need to be installed on both the development clients and the
>> > server?
>> > We have many development installs. If the SP changes are significant
>> > only
>> > to the server then installing it there only would be much more
>> > effective
>> > for
>> > us.
>> > Thanks
>>
>>