Data Driven Subscriptions

Hi !!
I want to create a scheduled delivery, with email & file share used together
with a single execution on a report. This means that i will sent the report
attachment thru an email to the recipient, and the same time copy that report
using the file share in a folder. Is this possible to implement?
This is because, I can only execute the report only once due to an updation
being done to the database.
Thanks - PeteSubscriptions only support sending through 1 delivery extension. Have you
looked into setting up the report to run on an Execution snapshot? This
would allow you to control when the report will run and all renderings of
the report will come off the snapshot and not the data. You could then
create two subscriptions running off either a shared schedule of when the
report execution snapshot is updated.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pete" <Pete@.discussions.microsoft.com> wrote in message
news:36D77E8B-1768-44AA-955E-D459516C7D41@.microsoft.com...
> Hi !!
> I want to create a scheduled delivery, with email & file share used
together
> with a single execution on a report. This means that i will sent the
report
> attachment thru an email to the recipient, and the same time copy that
report
> using the file share in a folder. Is this possible to implement?
> This is because, I can only execute the report only once due to an
updation
> being done to the database.
> Thanks - Pete

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
Chris
Backups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>

Daily Backups SQL 2005 Standard Edition

With SQL 2000 I was backing up to a NAS server by mapping a drive share to
Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
focused on a networking issue?
Thanks!
ChrisBackups are always done with the privileges of the account SQL Server is
running under. Does this account have access to that share? You never want
to use mapped drives. Use UNC pathing instead.
--
Andrew J. Kelly SQL MVP
"Chris Marsh" <cmarsh@.synergy-intl.com> wrote in message
news:eRk0J22LGHA.420@.tk2msftngp13.phx.gbl...
> With SQL 2000 I was backing up to a NAS server by mapping a drive share to
> Z. Is there a reason that I cannot do this in SQL 2005 now or should I be
> focused on a networking issue?
> Thanks!
> Chris
>