I am trying to extract blob data from a SQL SERVER 2008 R2 database. The data is annotation data that an application stores. I have done some research and I have been partially successful in converting the data. I get about 20-30 first characters of each entry. This is the SQL statement I used:
select CONVERT(varchar(MAX), CONVERT(varbinary, blob)) from annotation_data
How can I get all the data?