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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-10-31 : 18:14:03
|
| Hi,Is there any way to script out all operator from one instance to another. I can script one operator at a time. I am looking for a way to script out all operators during migration. Thanks |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-10-31 : 18:48:43
|
What operator are you referring to ?Whatever it is, if you are able to do one, you should be able to loop it and do for all.
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-10-31 : 18:56:22
|
| I can script operator by right clicking on each operator in SSMS. That is a manual procedure. If you have 100 operators then you have to right click on each and create script. These operators are under SQL Server Agent Node. I am looking for script to move all operators in one shot. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-10-31 : 20:42:41
|
CTRL-A to SELECT ALL and right click to SCRIPT AS
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-11-01 : 12:01:00
|
| Thanks for reply. Here is what I did:Click on operator folder in SSMS. Hit F7 to bring object explorer window. Multiple-select operators you want to script. Right click to script to new window, file etc. |
|
|
|
|
|
|
move operators