Whenever you try to replicate data from a database that saves the images(filestream) in the database, and you have included those images in your replication, then you might get this error
Solution:
There are two solutions for this problem
Length of LOB data (583669) to be replicated exceeds configured maximum 65536
Solution:
There are two solutions for this problem
- using TSQL
- sp_configure 'max text repl size', '2147483647'
GO
RECONFIGURE - using SQL Server Manager Studio
- In Object Explorer, Right click on your server name and select properties
- Click the Advanced node
- Under Miscellaneous option, change Max Text Replication Size to the desired value.
Great article its very useful.
ReplyDeleteWe can also submit our .net related article links on http://www.dotnettechy.com to improve traffic
Great article :) its very usefull
ReplyDeleteWe can also submit our .net related article link on http://www.dotnettechy.com to increase traffic
This is a community of .Net developers joined together to find solutions, to learn, to teach, to find interview questions and answers, to find .net website / blog collection