SET PARSEONLY / SET NOEXEC

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 11-Mar-2009 15:02:01   

I'd like to use LLBL to send a raw SQL statement to SQL Server to get back the schema and possible errors in for SQL.

I would need to send in either SET NOEXEC or SET PARSEONLY first, then the SQL then the same SET command to turn it off.

Is there a way to package up the SET ON, then **SQL **then SET OFF ?

Ian