Hi, I am writing a little app that will have a rich text box that users will be able to write SQL statements and save them to SQL Server table. I would like to validate the SQL statement before saving the string. Because another process picks up the string and executes it. Is there is object that will valiate a SQL string without actually executing it?

Thanks

u can give the command SET NOEXEC ON and then the sql query...it will just compile