Dears,[


Is it possible to make replication of objects. For example:

I have two servers (S1 and S2). Evertime I change a procedure on S1 I want
to alter the same procedure on S2.

I think I have to make a synchronization between the master databases of the
servers, but I don´t know if it is possible.

Thanks in advantage.

Rodrigo.

You can use the Copy SQL Server objects task and elect to drop and recreate
the objects each time.

Alternatively you can, and this is what I do, create ALTER scripts and have
them applied on the other server.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Rodrigo" <rborges11 (AT) hotmail (DOT) com> wrote