Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Command batch error

0 views

Skip to first unread message

unread,

Nov 11, 1997, 3:00:00 AM11/11/97

I prepared a SQL command file composed of inserts and updates. This
data is generated from a legacy system. The users will query on the MS
MSL data.

The command file is over 177,000 records, with about 16,000 inserts
and 16,000 updates.

I loaded the command file into the SQL Query Tool in Enterprise
Manager. I received the following message:

The SQL command batch has exceeded 64000 and cannot be executed

I then chopped the command file to contain only 32,000 records. Same
message. Can anyone advise?

unread,

Nov 12, 1997, 3:00:00 AM11/12/97

I assume your file is like this:

Insert into tblX (col1, col2) values ('abc', 'frd') => 16000 of them,
followed by 16000 of Updates etc...

Does your file include 'GO's anywhere?

--
Frédéric.

0 new messages