When you try to get content of text data long than 43.600 characters in SQL Server Management Studio — Query Editor, SSMS trims text after 43.600th character. If you want to see full content of column you can use this query: SELECT YourColumnName as [processing-instruction(x)]
