compile an sql query/script

[DanielaTm]

Hi,
I am making an script generator application in c# and I want to compile the generated script, not execute.
Does someone know how to do it? to call compile function of sql server?

Thanks,

[exterminator]

I guess you can do this with the SET NOEXEC ON option. Have a look at this - SET NOEXEC (http://msdn2.microsoft.com/en-us/library/ms188394.aspx)

Alternatively, I guess you can also use the SHOWPLAN to get the plan for the built script containing the query. If the queries are correctly prepared - it should show the info or else should fail - I am not sure what error messages will this throw up. But I would not advise on this. See if NOEXEC helps.

[DanielaTm]

Hi
Thank you! It is exactly what I wanted!

[exterminator]

Hi
Thank you! It is exactly what I wanted!You're welcome, Daniela. :)