SQL server 2000 reporting service SP2 question

[sugu]

Hi All,


I have created an application which generates reports using SQL server 2000 reporting service SP2. My client system is installed with SQL server 2000 reporting service SP1. Will the rdl files which i have created work with SQL server 2000 reporting service SP1?

Thanks!

-su

 

[robsuttonjr]

From Microsoft link:

http://www.microsoft.com/downloads/...89-1308-4662-8F58-CEC55EF1235B&displaylang=en

Installing SP2 modifies your Report Server databases. The upgraded database will not be compatible with pre-SP2 versions of Reporting Services. Back up the ReportServer and ReportServerTempDB databases using the SQL Server management tools. These backups will be necessary if you decide to reinstall SQL Server 2000 Reporting Services without SP2.

Regards,

Rob