reporting service database name

Hi,
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.
regards
-sarab> 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|||Additionally, you can use WMI to get all configuration settigs. Sample code
is in RS BOL, here is the MSDN link:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_wmi_4aci.asp.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message news:eRdZ%23l2sEHA.4040@.TK2MSFTNGP09.phx.gbl...
> > 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
>