Home Forums Reporting Services Reporting Services Identify All Reports That Have A Subscription Assigned??? (+ any underlying detail) RE: Identify All Reports That Have A Subscription Assigned??? (+ any underlying detail)

  • Many Thanks for your reply.

    Just to check , i need to be in 'SQL server Man Studio' ?

    I select OBJECT EXPLORER then CONNECT?

    From there, I select 'REPORTING SERVICES' and then choose our prefered server?

    This opens up the R_server within OBJECT EXPLORER with nodes of 'Jobs', Security' & 'Shared Scheds'.

    Upon the right clicking of these nodes, i get various options but nothing that resembles what i see in 'DATABASE ENGINE'. (This is the area I am confident with, the rest of this is new to me, SORRY!!).

    How do i run your suggested query against the RS database.

    I need to check i have permissions to run said report, how would i find out ??

    Again, thanks for being pacient with me, I'm self taught and every day is a new lesson (not to mention a headache) :-):-):-)

    Thanks again for any advice

    P