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 |
|
matador
Starting Member
3 Posts |
 Posted - 2008-04-17 : 14:32:07
|
| hi guys, I am migrating databases from one server to another , both the servers are in the same domain , i migarted the sceduled jobs associated with those database also , now one of the job calls a user created stored procedure for execution which is in the master database, since i just moved the user databases between the servers i need to create that stored procedure in the new master databse , is there a way i can do this ??-----LIFE IS SQLized |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-17 : 15:07:42
|
| why are you creating user SP on master database? There is a task in DTS package - transfer master SP . you can use that. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-17 : 15:09:54
|
| Just script out the stored procedure on the old server by double clicking on it or via the Generate SQL script wizard, and then paste this into Query Analyzer on the new server and run it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
matador
Starting Member
3 Posts |
Posted - 2008-04-17 : 15:33:25
|
| Thanks i scripted them out and they work fine on the new server |
|
|
|
|
|
|
Transfering user created stored procedure