Change Data Capture is not capturing before value for the Images
-
Hi, I have a table which has many Columns among those Columns two Columns hold Image Datatypes, when we update the Table contents CDC is Capturing fine but its not capturing the before value for it but it is capturing the after value though. I am not sure is it happening because of the Entity Framework or CDC or my team is implementing Image update in a wrong way. Please any type of help a code snippet, a link or even a suggestion helps me a lot - thanks in advance buddies.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
-
Hi, I have a table which has many Columns among those Columns two Columns hold Image Datatypes, when we update the Table contents CDC is Capturing fine but its not capturing the before value for it but it is capturing the after value though. I am not sure is it happening because of the Entity Framework or CDC or my team is implementing Image update in a wrong way. Please any type of help a code snippet, a link or even a suggestion helps me a lot - thanks in advance buddies.
Thanks, Abdul Aleem "There is already enough hatred in the world lets spread love, compassion and affection."
By default, the maximum size that can be added to a captured column in a single INSERT, UPDATE, WRITETEXT, or UPDATETEXT statement is 65,536 bytes or 64 KB.
What is the size of your blob? Does it work with nvarchar(max)?
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)