Replication of indexes, triggers, constraints in MS SQL Server 200

Hi,
Is there any better means of replicating table indexes, triggers, and
constraints than simply reinitializing the article everytime their
definitions change or a new one is added? This is in Microsoft SQL Server
2000 SP3.
Many thanks,
Oskar
sp_addscriptexec
It only works for subscribers deployed via a UNC.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:469DF5DA-6394-477E-B8DD-915E0E48072A@.microsoft.com...
> Hi,
> Is there any better means of replicating table indexes, triggers, and
> constraints than simply reinitializing the article everytime their
> definitions change or a new one is added? This is in Microsoft SQL Server
> 2000 SP3.
> --
> Many thanks,
> Oskar
>