Post reply

stored procs - registering

  • March 6, 2007 at 4:09 pm

    #172622

    Hi,

    I have some stored procs in VSS. I want to get them and register them against a db in a particular sequence.

    (If i have proc1.sql, proc2.sql, proc3,sql - i do a fresh get and i want to register proc3.sql first followed by proc1.sql, proc2.sql)  - Is it possible to do?

    Thanx.

  • March 7, 2007 at 9:19 am

    #693606

    Make yourself an old fashioned DOS Bat file that runs OSQL on each of the procs, one at a time.  Then the procs will be installed in the order of the bat file.

     

    OSQL -i Proc3.sql -S Server -D Database -U Userid -P Password

    OSQL -i Proc1.sql -S Server -D Database -U Userid -P Password

    OSQL -i Proc2.sql -S Server -D Database -U Userid -P Password

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

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