Compile programatically

  • Hi,

    I am developing a C# application that generates sql scripts. I want throw c# to compile the resulted script. How could I do that? Is any system sp that 'does' the compile , a function that I could call?

    Thank you


    Daniela

  • SET

    NOEXEC ON

    GO

    Insert that at the top of your script and execute it.  It will be compiled (syntax and object names will be validated), but not executed. 

    -Eddie

     

    Eddie Wuerch
    MCM: SQL

  • thank you Eddie. It helped a lot


    Daniela

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply