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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-09 : 08:10:45
|
| sdekha76 writes "I am planning to implement Trans.Repl. have a question:I want to set a flag in table which Repln Agent can read and trigger Trans. Repln. process. Has anyone tried this?That way I dont need to set specific time (or interval) to run agents." |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-09 : 21:39:33
|
quote:
Originally posted by AskSQLTeam
sdekha76 writes "I am planning to implement Trans.Repl. have a question:I want to set a flag in table which Repln Agent can read and trigger Trans. Repln. process. Has anyone tried this?That way I dont need to set specific time (or interval) to run agents."
instead of transactional, try snapshot, then create the job to run the agents based on the values in the table--------------------keeping it simple... |
 |
|
|
|
|
|
Trans. Replication