title: Linked SQL Server and Update a Varchar(MAX) is truncated
body: <p>I have a number of databases to maintain, and I don't want to create a script for each environment, so I created synonym in combination with a linked server to abstract away tables for my update statements.</p>
  
  <p>My problem is that I can't seem to update a varchar(max) field with more than 24-32 characters (and it varies!)</p>
  
  <p>I've been researching the web, and I can't find anything that directly speaks to this.  (UPDATE: Linking to my workstation, rather than to a server across the network, the local linked sql server updates fine.I think this is a environment issue on part of the host?  Perhaps some defined limit?)</p>
  
  <p>Below is an example of how I have set things up.</p>
  
  <pre><code>--I create some dynamic sql to create the sysnonyms for me.
  declare @Synonym varchar(30) = 'sym_Employee'
  declare @DBTable = 'Employee'
  Select @Stmt = 'create synonym ' + @Synonym + ' for TargetSQLServer.' + @DBName + '.dbo.' + @DBTable + ';'
  exec @Stmt
  
  --this statment stops at 24 chars, but the column def is varchar(max)
  update sym_employee
  set Notes = '012345678901234567890123456789'
  where employee_ID = 1
  </code></pre>