Updating text columns at subscriber of updatable transaction replication

by dotnetpete 15. March 2009 11:17

Just a small gotcha with updateable transaction replication which I only found out the hard way, which is, Text columns are not updateable at the subscriber! Tar and feather me if everyone but me knew this but it's a pretty big gotcha if you ask me.

Luckily varchar(MAX) to the rescue and row sizes about 8092! All good after that. 

 

Tags:

SQL | SQL2008

Add comment




biuquote
Loading