| Author |
Topic |
|
ruipfm
Starting Member
3 Posts |
 Posted - 2012-03-16 : 14:01:19
|
| Hi.I have a replication (Transactional publication) and I would like to create triggers at subscription database. Is it possible? I have tried but I can't.I can't create triggers at the original database because it is not mine and it is closed. I only can read it.Please help me.Thank you.Rui |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-16 : 14:47:34
|
| you can create triggers at subscriber. Can i ask what you're trying to do with them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
ruipfm
Starting Member
3 Posts |
Posted - 2012-03-17 : 18:52:21
|
The original database are used by a commercial software and if I create triggers in database the software doesn't work because it detects that the database was changed.I want to create triggers because I want to develop an application over the database in order to monitor some tables and data. So, I tought create a replication, but when I created triggers in subscriber, it doesn't synchronize anymore with the original database.I don't know what's the matter.quote:
Originally posted by visakh16
you can create triggers at subscriber. Can i ask what you're trying to do with them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-03-17 : 21:27:31
|
| What's the acceptable latency for your app? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-18 : 12:06:53
|
quote:
Originally posted by ruipfm
The original database are used by a commercial software and if I create triggers in database the software doesn't work because it detects that the database was changed.I want to create triggers because I want to develop an application over the database in order to monitor some tables and data. So, I tought create a replication, but when I created triggers in subscriber, it doesn't synchronize anymore with the original database.I don't know what's the matter.quote:
Originally posted by visakh16
you can create triggers at subscriber. Can i ask what you're trying to do with them?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
did you read link i posted?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
ruipfm
Starting Member
3 Posts |
Posted - 2012-03-19 : 07:51:47
|
| Yes, I did. I learnt that triggers at subscription are only acceptable in merge replication, transactional replication with updatable subscriptions, or peer-to-peer transactional replication. But this type of replication creates a unique identifier in both database. I can not do this, because I can not modify nothing in original database.I would like only few seconds of latency.Can you help me, please?Thanks.[/quote]did you read link i posted?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/[/quote] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-19 : 09:05:22
|
| then try creating a sql agent job which executes the required logic and set a schedule to execute it frequently.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Triggers in replication database