Post reply

Scripting a batch program to load stored procedures

  • November 30, 2006 at 10:26 pm

    #61732

    I am using sql server 2000 with multiple databases. I need to update the stored procedures on all some of the databases. I would like to do this via a dos batch program that will invoke osql, iterate through a file which contains all the items that I to update. How would I do this?

  • December 1, 2006 at 11:09 am

    #675213

    Could you use EXPORT/IMPORT utility to generate scripts for you?

  • December 3, 2006 at 2:41 pm

    #675380

    I could use export to generate the scripts, but I cannot use import to import the scripts.

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

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