I'm having some problems with SQL Server 6.0 Replication.
* I have some table which contain Text columns. When the table is
replicated, the Text columns are replicated as Null. Initially I had created
the publication as transaction based. Yesterday I changed it to scheduled
table refresh and it is still doing the same thing. I have SP3 installed. Is
there a way out. The Text fields are critical and without them the other
details will not be of much use. Any suggestions??.
* Is there a way to partition a table horizontally based on rows in other
table. What I want to do is this. The Application that I'm developing will
be run on Head office and Branches. The Head office creates all the Employee
records which is to be replicated to the branches. Along with the Employee
records, some other records get created. How do I replicate the data in the
other tables to the respective branches. The Employee table contains the
branch code. What I did was to give a sub query in the filter clause.
For eg, for the Allowances table I specified the filter clause as
EA01_EMP_NO IN (SELECT EM01_EMP_NO FROM EM_EMPLOYEE WHERE
EM44_CURR_BRNCH = 'CSP').
This does not seem to work. I went thru the Technet last night and found out
that this is a Bug and has been fixed in SP2. I installed SP3 and it is
still not working.
Please help. I'm stuck with these problems.
Thanks in advance