do anyone have an idea?

Hi there,

I have number of tasks in my control flow most of them are execute sql task. I want to update one of the column in my table when anyone of the task in the control get fails?

Please let me know if anyone have an idea how to do this.

Thanks and Regards

I think 'event handlers' can do that for you. I dont have specific examples now; but this forum has a lot of info on that.|||

Hi Salas,

You are right.I have done it by using event handler.

Thanks a lot.

Distribution database

Do we need to do any maintenance tasks on distribution database in
transactional replication after the replication is setup..?
Any advise...
Regards,
Ravi
No, there is a distribution clean up agent which will prune the distribution
database of replication metadata.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"SQL Replication Guy" <SQLReplicationGuy@.discussions.microsoft.com> wrote in
message news:2248D094-CD16-4F9F-82CC-C38E19BAFFD1@.microsoft.com...
> Do we need to do any maintenance tasks on distribution database in
> transactional replication after the replication is setup..?
> Any advise...
> Regards,
> Ravi
|||In terms of removing metadata please see Hilary's reply. In terms of disaster
recovery, it depends on what your strategy is. If you're using transactional
replication, then there should definitely be a backup plan in case of the
database and transaction logs. Because of the way merge works this is less
important in terms of keeping perfectly up to date, but is still required if
you don't want to reset up replication in any way.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)