Re: Programatically create replication publication?



Terry,
please have a look at the SQLDMO and ActiveX scripts on this page:
http://www.replicationanswers.com/Scripts.asp.
Also, you might want to investigate creating a replication setup in a test
environment, having enterprise amnager script out the setup, modifying it
then using this as a starting point for your setup. This would achieve the
same ends, but be entirely in TSQL.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.



Relevant Pages

  • RE: Installation
    ... To run Unattended SQL Server setup at Command Prompt, ... How to record an unattended installation file ...
    (microsoft.public.sqlserver.setup)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... Please try the following steps and then run the SQL Server 2000 setup again: ... Can we install SQL Server successfully at this time? ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: setupsql.exe hangs. Cannot Install SQL server 2K
    ... Q. When I run the SQL Server 2000 setup, ... Q. What should I do if the installation of SQL Server 2000 is unsuccessful? ... Access Components (MDAC) setup, which is launched as part of the SQL Server ...
    (microsoft.public.sqlserver.programming)
  • Re: x64 2003 Cluster - SQL2000 named instance fail
    ... one the settings are not detected by the setup. ... > in the cluster log you will notice the a connection to the SQL Server ... > named instance cannot be established. ... >> Microsoft highly recommends that users with Internet access update their ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... I understand that the SQL Server 2000 Setup Control ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)

Loading