How to retrieve a report in SQL Reporting Server

Is there a way to read the rdl file that is already deployed on the Report
Server to modify it? I have some reports on RS but don't have the original
rdl file.
Thanks
AyadAyad,
Open Report Manager (http://localhost/reports), select your report and
click the 'Properties' tab. You'll see a section on the page called
"Report Definition". Click the Edit link and you'll have the RDL.
Andy Potter|||To extract multiple disparate reports at the same time you could also use
Reporting Services Scripter
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Ayad" <ashammout1@.hotmail.com> wrote in message
news:O5WPL1LDGHA.740@.TK2MSFTNGP12.phx.gbl...
> Is there a way to read the rdl file that is already deployed on the Report
> Server to modify it? I have some reports on RS but don't have the original
> rdl file.
> Thanks
> Ayad
>

How to restrict users to particular databases

While web hosting I use Sql Server 2000 as the database. Imagine I have hosted 3 Web Sites. All these 3 users want to modify/update their designs. What I did is I created respective 3 users having access to the respective databases only. So that they can registerd the ip and add to the Sql Server 2000 Enterprise Manager. These users are able to access their own databases only. But all these 3 users are able to access the default databases like master,pubs etc. How to restrict this.

Also suggest which is the optimal way to give control to the respective users while using Sql Server 2000.

====Suresh, P.R, Postal Training Centre, Mysore.

Hi,

Pubs is a samples database, for the rest have a look on:

http://groups.google.de/group/microsoft.public.sqlserver.security/browse_frm/thread/b4f926814e2678e9

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||... and on production servers it is best to drop PUBS & NorthWind databases.