DTS error

[gusset]

not just DTS, but also in some of my queries.

when i try to transfer a table from a Sql Server 7 database on one server to a Sql Server 6 database on another, the operation fails, with a message to the effect that the query optimiser didn't like the fact that there were more than 8000 bytes in the GROUP BY clause.

there is nothing special about my table that i can see; it has around 20 fields, of mixed datatypes, three nvarchar fields of 4000 bytes.

i have tried leaving out some of the fields but short of trying all the possible permutations, feel sure that this must be something to do with the fact that i am transferring into an older version.

does anyone have a suggestion?

thanks

g

 

[gusset]

i had not realised that a fieldsize was large.

g

 

[billchris]

It sounds like the query that DTS is calling to transfer the data is doing a group by on one or more of the nvarchar(4000) fields. I assume that you are trying to summarize the data as you are moving it.

I would try moving the data to an intermediate table on the destination server without summarizing it. Then you can do the summarization in multiple steps on the destination server.

Hopefully, you can find a way to do the summarization without including nvarchar(4000) fields in the group by clause. (That doesn't seem like a good idea anyway, because it seems like it would be really slow.)



“I apologize for this long letter. I didn't have the time to make it any shorter” --Blaise Pascal