scheduling snapshot and synchronization is missing on the generate scripts

hello all,

i need to bring down the entire replication solution

but just before i do that i need to script. The EM has a generate script feature

but it lacks the schedule for snapshot generation and synchronization

by the way,

whats the fastest way of melting the entire replication solution and

then brinnging them back again.

Can i do replication backup and restore?

regards,

joey

use <published db name>

exec sp_removedbreplication <published db name>

go

use master

sp_dropdistributor 1

go

You can use sp_removedbreplication on the subscriber database as well, and if you have a remote distributor, you can run sp_dropdistributor 1 to remove the distributor.

After that, you can apply your scripts.

sql

Scheduling Report to render in to PDF format

Hi,
I have a report with 25 subreports which needs to generate one pdf file on
schedule basis (ie. schedule report to render in to PDF format based on some
time and date setting).
Is there any way of doing this?
Thanks in advance for the helper.
Regards.
AnithaYou need to subscribe to the report. As part of the subscription parameters
you can define the schedule of when you want the report to be automatically
generated.
Keep in mind that you have to also define a dafault value for each parameter
in your report.
Hope this helps,
Tigan
"Anitha Naidu" wrote:
> Hi,
> I have a report with 25 subreports which needs to generate one pdf file on
> schedule basis (ie. schedule report to render in to PDF format based on some
> time and date setting).
> Is there any way of doing this?
> Thanks in advance for the helper.
> Regards.
> Anitha
>