>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?

You should have a CRUD level SP for each version of CRUD requests. Now you can STOP access to your tables from Selects within SQL Server or Excel,... and only via SPs.

CRUD = Create, Read, Update, Delete.

HTH