I am trying to store an html page in a table that I want to email from my
Stored procedure, but have run into a couple of problems.

I originally stored it as a Text field (to take care of the 8000 varchar
limit), but I apparently can't use Text as a local variable to read the data
into.

I then tried to use a varChar(8000) as the test file I am using is only 3800
characters.  The problem is that when I do a select to get the data, I only
get part of the data (1023 chars, which I determined from doing a len).  So
when I email it, only part of the html file gets sent.

How do I deal with this?

Thanks,

Tom

Can you post the code snippet where you try to select and email the data ?
Based on your narrative it might be an issue with interface limitations.

I found the problem.

It was the fact that I was using EM to insert my data and apparently there
is a 1023 character limitation with it.

When I inserted the record using Query Analyser, it worked fine.

Thanks,

Tom
Show quoteHide quote

Count Occurances in a column
Who has the highest bid?
Need Help Please...
How to compare strings for equality in Transact SQL
Why does doing update in chunks works faster than doing the whole?