i believe the extended property in question is getting CONVERTed into a varchar field with no definition.
if you cast/convert something as a varchar without a size, it defaults to a varchar(30), and you'd see the truncation issue you are observing now.
declare @STR varchar(100)
set @STR='this string is actually 43 bytes in length.'
select convert(varchar,@str)
results:
this string is actually 43 byt
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!