Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Pan Ziuzia
Starting Member
1 Post |
 Posted - 2003-03-06 : 09:05:17
|
| Hello!Suppose, I have some NOT FOR REPLICATION trigger on some table. This trigger is NOT fired only when replication agent is modifying data in the table. Does any body know, how MS SQL Server detect connected replication agent and what replication agent must do for do not fire NOT FOR REPLICATION trigger?Thanks. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-10 : 23:54:42
|
| NOT FOR REPLICATION applys to how identity columns are handled during replication. It has nothing to do with triggers.-Chad |
 |
|
|
PiecesOfEight
Posting Yak Master
200 Posts |
Posted - 2003-03-17 : 11:39:40
|
| The way in which SQL Server determines that a replication agent is performing an operation is not documented. NFR (Not for Replication), however, does apply to triggers as well as identity columns. BOL isn't very clear on this, but if you check CREATE TRIGGER, you will see an NFR option. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-17 : 15:44:56
|
You are right. I guess you learn something new everyday.I knew there was a reason I typically stay out of the Replication forum.  -Chad |
|
|
|
|
|
|
NOT FOR REPLICATION question