When using Syntax 1 of the FORWARD TO statement via EXECUTE IMMEDIATE to send a big fat SQL statement to a remote database, is there a formula for calculating the maximum size of the SQL statement that can be sent?

In this old question-and-answer Nick Elson seems to indicate that it is the source database page size less 88 bytes.

asked 02 Mar '12, 16:26

Breck%20Carter's gravatar image

Breck Carter
26.2k430600863
accept rate: 20%

Interesting limit - may this be connected to the data limit one can pass to other connections via the MESSAGE statement?

It' Saturday - time to guess - Monday may bring an answer:)

BTW: Are you sure this question should not be tagged with neither "debugging" nor "performance"?

(03 Mar '12, 09:55) Volker Barth
Replies hidden

Tag away, Volker... you know how much I care about tags :)

(03 Mar '12, 11:13) Breck Carter
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×26

question asked: 02 Mar '12, 16:26

question was seen: 663 times

last updated: 03 Mar '12, 11:13