RE: Releases, replication, and scheduling

Hi!
I have a replication setup on my servers. However, everytime I do a
release of a new SQL Code that affects articles of one of the
replication I have to drop it and re-create it. Is there a better way
to do that? Is there a tool that can automate it.

Also, I have big scripts (3 to 4 pages of code) that need to be run at
around 3 - 4am. I usually put them in the file and then run them
manually. Is there a stored procedure or a tool that will allow me to
automate that? I would like to be able to schedule this job and pass
the file name and what database it affects.

Thank you,
T.

.

Loading