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 - 2006-09-22 : 10:15:20
|
| Majid writes "Hi,I have setup a transactional replication that accept data tranformation (under sql 2000) in order to setup a horizontal filtering by subsriber. This is because I have some articles that I would like filter by subsriber.I read the steps in book on line how to setup this. But I could not achieve my work when I tried to create package that make the filtering. I was surprised when I tried to put the filtering formula, to see that I have to enter it in VB and I am not familiar with that language.Could you please help me. I appreciate.Regards.Majid" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-22 : 13:19:22
|
| Why not just modify the replication stored procedures to do the filtering? Use these instead of INSERT/UPDATE/DELETE statements. The sprocs will be named:sp_MS<DMLOperation>_TableNameHere is an example of ours: sp_MSdel_compopt.Tara Kizer |
 |
|
|
|
|
|
Transactional replication with Horizontal filtering