"bmurtha" <anonymous@discussions.microsoft.com> wrote in message
news:7ce501c47735$e821d580$a301280a@phx.gbl...
> Hey All,
>
> I setup a log shipped server so we could have a warm
> backup but the only way I could make the business case to
> spend the money was to use it as a reporting server as
> well. Needless to say, people are not that happy about
> getting kicked out all the time when the data is loading.
> Is there anyway to mask the fact that the data source is
> unavailable and just get reporting services to wait until
> the load is done and resubmit the query when the
> connection is available again.
>
> Thanks,
> Bryan