| 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 MVP
http://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 MVP
http://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 MVP
http://visakhm.blogspot.com/
did you read link i posted?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://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 MVP
http://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 MVP
http://visakhm.blogspot.com/
|
|
|
|
|
Triggers in replication database