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 |
|
ajkla
Starting Member
3 Posts |
 Posted - 2007-12-06 : 08:36:53
|
| I have started a transactional replication between two SQL2000 servers. One of the fields being replicated is of type TEXT(16) on both servers, however on the replica the data is being truncated to 65000 characters. This I know since I checked the DATALENGTH on both servers, on the original it is 239,361, and on the replica it is 65,000. So I am losing data in the process.I tried Importing the data using the DTS Wizard and the data is fine, so replication is the problem. I have also used EXEC sp_configure 'max text repl size', '2147483647'andexec sp_tableoption 'tablename','text in row','7000'to no avail. Any help will be massively appreciated.Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-12-08 : 00:30:54
|
| You changed that option on the Publisher right?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
ajkla
Starting Member
3 Posts |
Posted - 2007-12-08 : 09:56:31
|
| If by option you are referring to the EXEC sp_configure 'max text repl size', '2147483647', yes I did it both on the Publisher and the Subscriber. I also executed the 'RECONFIGURE WITH OVERRIDE' after both setups.As for the other option, exec sp_tableoption 'tablename','text in row','7000', I only did it on the Subscriber because I'm not sure if this might effect the live data I have on the Publisher. |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-12-08 : 13:12:07
|
| I havent used the sp_tableoption yet. We are replicating frm 2005 to 2000 and we have text columns. I ended up using sp_configure to 132k and we were fine. Run sp_configure and see if the option actually got affected.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-08 : 17:46:59
|
| Ensure run value of the option is what you set. |
|
|
|
ajkla
Starting Member
3 Posts |
Posted - 2007-12-10 : 02:52:06
|
| I ran the sp_configure once again, to no avail and the run_value is set to the max. |
|
|
|
|
|
|
|
|
Replication of TEXT field