Hi all,
I have a OpenQuery function that in the Select statement the lenght of
it is above 8000 characters, and it get into error when I run the
query.
Is it possible to by-pass this problem?

Thanks a lot.

You need to use an NTEXT field, along with all of it's limitations as the
largest NVARCHAR or VARCHAR is 8000 bytes (4000 characters for NVARCHAR).

Robinson ha scritto:
Yes, but my Select statement in inside the OpenQuery, not a variable
(an OpenQuery doesn't accept parameters).
Like this one:

SELECT * FROM OPENQUERY (XPDB,
''SELECT  BUTE0.FM_BOST.SOC_MASTER,
...................................
......................................
.................................
-- up 8000 characters
..........................")

**SORT THE PHYSICAL ORDER ON A TABLE'S COLUMNS**
INSTEAD OF TRIGGERS DO NOT SUPPORT DIRECT RECURSION
problem with synonyms
Explain this please!
XP_CMDSHELL Problem
SQL 2005 slower than 2000?
TABLE FUNCTION
Generate intervals
Dynamically flattening a table
Passing tableName as parameter to SP