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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-05-16 : 03:51:23
|
Hello ,I have configured a transactional replication from SQL 7.0 to SQL server 2000 .SQL 7.0 server is a publisher and SQL 2000 server is a subscriber . When i try to insert image greater than 64 KB it gives me an error message that replication supports only 64 KB . Otherwise it works well. This specific replication works over the firewall . So i really don't know whether its a problem of the firewall or the SQL Server configuration at both the ends .Any help would be appreciated .Thank you very much .Regards,Jerry .  |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-16 : 08:11:56
|
| SQL Server defaults to a maximum of 64K when replicating text/image columns. You can change this using sp_configure with the "max text repl size" option:sp_configure 'max text repl size', '1000000'RECONFIGUREThat's set for a 1 million byte column size, you can increase it up to 2 billion. Books Online has more details under sp_configure. |
 |
|
|
|
|
|
Image Replication error . Please Help !!