April 14, 2008 at 11:47 pm
i was wondering if anyone know where I can find the code to create a new distribution agent (transactional replication) and make it the active agent.
right now, i have to manually perform this task and would like it to be automatic via a sproc.
Thanks.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
April 15, 2008 at 9:48 am
1. create the transactional pub via SSMS GUI
2. create the transactional sub (with the same push/pull that you want) via SSMS GUI
3. generate scripts for same
4. edit and prettify scripts (the raw code is somewhat difficult to read)
5. use, enjoy (infinity and beyond!)
April 15, 2008 at 12:13 pm
that wasn't my question ...
I have already scripted out everything, by hand. I can't find any t-sql code to create a new distribution agent. The distribution property doesn't allow script functionality
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply