rdrunner400
Programmer
Hi,
I am supporting an application which we deploy onto remote servers. That goes fine.
My Question is .... we deploy the Application on a Server and at each release we have to run about 15 - 20 Stored procedures on the server. There are 10 sites that we deploy it on ... and I am looking for a way to run all the SP's that are included in each release either as a Batch that can be included into the Installer .... or as a separate process that I as the person who is installing the new release onto the server can execute similiar to the old batch file ... where you added the various lines that you wanted to run.
The version of SQL that resides on the server is currently 2008 R2 Express. In all cases there are about 10 pc's that has an application installed that connects remotely to the server.
Currently if the SP's are rather large in can take up to an hour to run some of them hence why i am looking for another way.
Any help would be greatly appreciated.
rdrunner40
I am supporting an application which we deploy onto remote servers. That goes fine.
My Question is .... we deploy the Application on a Server and at each release we have to run about 15 - 20 Stored procedures on the server. There are 10 sites that we deploy it on ... and I am looking for a way to run all the SP's that are included in each release either as a Batch that can be included into the Installer .... or as a separate process that I as the person who is installing the new release onto the server can execute similiar to the old batch file ... where you added the various lines that you wanted to run.
The version of SQL that resides on the server is currently 2008 R2 Express. In all cases there are about 10 pc's that has an application installed that connects remotely to the server.
Currently if the SP's are rather large in can take up to an hour to run some of them hence why i am looking for another way.
Any help would be greatly appreciated.
rdrunner40