Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
aex
Yak Posting Veteran
60 Posts |
 Posted - 2006-06-13 : 22:35:29
|
| Hi, I have 5 stored procedures, and my problem is each time I transfer these sp to another pc, I have to open the sp separately and store it (i mean create the sp) into DB. Is there any command that can help me to run these sp in a time?Thanks in advance for any reply.aex |
|
|
darinh
Yak Posting Veteran
58 Posts |
Posted - 2006-06-14 : 00:07:46
|
| If you are trying to keep the stored procs on 2 databases in sync, then you could script your changes on one and execute them through Query Analyzer on the other.Alternatively, you could use something like thishttp://www.red-gate.com/products/SQL_Compare/index.htm |
 |
|
|
aex
Yak Posting Veteran
60 Posts |
Posted - 2006-06-14 : 00:34:18
|
Thanks for the reply, darinh. The tips you suggest is really useful.  aex |
|
|
|
|
|
|
How to run many stored procedures in a time?