August 3, 2005 at 3:51 am
Hello to all.
One of our datawarehouse developers generated a very large query by means of one of his tools. Although the sql is really a select (select count...) query ananalyser returned an error as there are to many fields in the Update.
I don't include this query here because of his size (150 complete lines), but if someone wants to receive it, I will send it.
Anyone an idea of this and in particular of the query limits for mssql2000 ?
August 3, 2005 at 4:42 am
What exact error message did you get? The limitations that might come into play here are:
Columns per SELECT statement: 4,096
Columns per INSERT statement: 1,024
Length of a string containing SQL statements (batch size): 65,536 * Network packet size
Network packet size is by default 4KB but can be changed with sp_configure.
August 3, 2005 at 5:42 am
Problem solved. Our developer recreated the query manually.
After that all worked as desired. Thanks for your reply.
August 3, 2005 at 6:30 am
What was the problem?
August 3, 2005 at 7:36 am
The basic problem stays unknown. The developer splitted his sql statement and it worked ! Probably something that went beyond the sql limits. We don't have time to spit it out now.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply