Funny story. I didn't get all the info from my developer and it turns out that it is Access that is truncating the data. (long story). Anyway, it's...

We use ADO connection object.

quote:

---

What method are you using to connect to SQL Server?

Gregory Larsen, DBA

If you looking for SQL Server Examples...

Same problem. The @@TEXTSIZE says 64512.

quote:

---

Are you having the same problem with your web page, and/or application? Have you looked...

That worked for Query Analyzer, but how about for a select statement from a application or web page?

quote:

---

If you are using QA...