1
Vote

Error with FK & database trigger

description

I was inserting a column via table design in SSMS and upon tryign to save I got
"Unable to create relationship <fk name>. Target string size is too small to represent the XML instance" where <fk_name> is the name of my foriegn key which is just an INT. There are around 15 other FK's in this table but this was the only one reporting this error.
I've never seen this error before but disabling the standardCDC database trigger made it go away and I could save my design changes.
 
Regards
 
Derek

comments