I have a strange bug:
On my development machine (sqlexpress) I have a text column that is storing a long text string (~100k) into the column. Everything works fine. However, when I deploy to production (sql server 2005 standard) all the text fields are truncated at 65k. The same is true of varchar(Max).
Not sure what is causing this.