>>Thank you. So when you are saying 'kilobytes of text' you mean there is no limit on the length of the SQL command that you send to SQL Server?
>
>I think it's 8 kilobytes per single command. I've seen insert command failing (even on a cursor adapter), or a create table, with 200 fields and too many options or long values. The length of a string passed may be limited by the ODBC driver, but I'm regularly sending about 18K of script at a time without a problem. Don't know whether even the oldest one in use (for SQL 2000) has a limitation.
Thank you. For the most part I know use SQL Server 2008.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham