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 |
|
Delinda
Constraint Violating Yak Guru
315 Posts |
 Posted - 2008-05-17 : 05:44:54
|
| I'm using SQL Server 2005I'm made 4 stored procedure and save it assp_process1.sql, sp_process2.sql, sp_process3.sql and sp_process4.sqli want to deploy all above SP to another machine. So far, i open it 1 by 1 and click execute in SQL Query windows 1 by 1.How to open all .sql files but execute it once. Is it possible? Anybody know the way?What the best way to deploy stored procedure into another machine? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-17 : 10:37:43
|
| First of all don't name your store procedure starting with 'sp' as it has to go through master database and find .Second, You can use Generate script task in task option to create script and save as file ,deploy it to wherever you want. |
 |
|
|
Delinda
Constraint Violating Yak Guru
315 Posts |
Posted - 2008-05-17 : 11:32:58
|
| tq mr. sodeep. your info really great. |
|
|
|
|
|
|
Open more than 1 .sql file then execute it once