Subject | Technical Question for the experts. |
---|---|
Author | Dalton Calford |
Post date | 2000-05-09T20:02:06Z |
I know this is not the appropriate forum for this question, but, I know
that all those who would be in the know, monitor this forum closely.
I am getting a weird error and the only thought is that thier is a
maximum
size of statement that can be sent to the client to the server.
My situation is, I have a series of triggers, which build sql statements
for a simple roll forward log.
Unfortunately, the trigger for a particular table is 124 K in size (due
to
being a legacy table that has far too many columns but also has too many
client apps using it).
WISQL says 'Single isql command exceeded maximum buffer size'
what I need to know is how big a buffer actually exists and how much I
need to trim to get this thing working.
Any help would be greatly appreciated.
best regards
Dalton
that all those who would be in the know, monitor this forum closely.
I am getting a weird error and the only thought is that thier is a
maximum
size of statement that can be sent to the client to the server.
My situation is, I have a series of triggers, which build sql statements
for a simple roll forward log.
Unfortunately, the trigger for a particular table is 124 K in size (due
to
being a legacy table that has far too many columns but also has too many
client apps using it).
WISQL says 'Single isql command exceeded maximum buffer size'
what I need to know is how big a buffer actually exists and how much I
need to trim to get this thing working.
Any help would be greatly appreciated.
best regards
Dalton