Anytime you deploy multiple SQL Servers or multiple instances of SQL Server within an organization, you will need a way to handle routine server-to-server administration tasks. For example, if you have a database on one server, you may need to copy users from one server to another. SQL Server 2005 allows you to automate routine server-to-server administration tasks using scripts. You can write the scripts to the Query Editor or save them to a file for later use.
The server-to-server administration tasks you can automate include:
Copying users, tables, views, and other objects from one database to another.
Copying alerts, jobs, and scheduled jobs from one server to another.
The subsections that ...