Does anyone know what the limit (if any) the text is that you can pass to the Command object for SQL queries? Basically, I wanted to add the ability to take a script file that may have any combination of CREATE, ALTER, INSERT, DELETE, etc... commands and process them all. Problem is that I have no clue how big these script files may get...they could theoretically get pretty big, and I was curious what the sting limit was that I can pass was.
Also...has anyone else attempted to do a similar thing as this in their apps..I mean allowing you app to accept script files and process them against a SQL database?
________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook