Post reply

compiling procs

  • December 8, 2003 at 2:21 pm

    #59558

    Does anyone know of an easier way to release procedures in a database say thru a cmd file (ex if there are 100s of procs to be compiled at the same time one after the other. any help will be greatly appreciated.

    TIA

  • December 8, 2003 at 3:30 pm

    #485200

    If the stored procedure are all in one file you can just run that file using OSQL. If they're in individual files you could do a bit of coding in T-SQL or VBScript to run each file using the same OSQL utility.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

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

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