> Is there a way to find out(via table lookup) which database in an
> given instance serves as a reporter database?.
>
> More specifically, i need to report on some reprots and i do not want to
> check every database in an instance to find out which one is used by
> reporting services.

> > Is there a way to find out(via table lookup) which database in an
> > given instance serves as a reporter database?.
> >
> > More specifically, i need to report on some reprots and i do not want to
> > check every database in an instance to find out which one is used by
> > reporting services.
>
> In Query Analyzer, use
>
> EXEC sp_who2
>
> and check the DBName column in the row where the ProgramName coumn has
value
> 'Report Server'. Use the lowest SPID value if there are more rows with
> identical info (lower SPID=ServerProcess ID means earlier connection;
> services should be faster when connectiong to SQL Server than regular
> users).
>
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>