March 1, 2012 at 7:58 am
Hi, All
I've encountered a problem about the data size. One of the table column is xml type and it will exceeded the max text repl size (1000000) easily.
My solution is do not replicate that xml column (subscriber needn't this column info). After I doing some study I've found 3 ways to do it:
1. sp_repldropcolumn
2. sp_articlecolumn + sp_articleview
3. Change 'max text repl size' to 2147483647 at server level.
I wonder if both of 1st and 2nd can resolve the repl size issue. I just found sp_repldropcolumn will drop the column from the publish property GUI actually but the sp_articlecolumn one will keep that column unticked. The 3rd one is simplest, but is there any impact?
Do you have any experience about it? Which one is better or do you have other suggestions?
Regards
Billy
March 10, 2012 at 3:56 am
The first option looks not good as MSDN said:
Important:
This stored procedure has been deprecated and is being supported mainly for backward-compatibility. It should only be used with Microsoft SQL Server 2000 Publishers and SQL Server 2000 republishing Subscribers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply