proc to script publication info | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

proc to script publication info


I was browsing BOL for the sp_ to script a publication + subscriptions but couldn’t find any. I found the section "scripting replication" and it only had sql-dmo and ent. manager examples but no stored proc listings. searching for sp_script* didn’t turn up anything anyone heard of such a procedure, (so I can schedule it) ?
I haven’t seen such tool with pre-supplied SPs and SQLDMO is only available to do so. I think uou can script the replication, by using EM, go to ‘Tools/Replication/Generate Replication Scripts…#%92 to generate replication scripts. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>