How to Publish Data Over the Internet (Transact-SQL)

How to Install SQL Server 2000

How To

How to Publish Data Over the Internet (Transact-SQL)

To publish over the Internet using snapshot replication (Transact-SQL)

  • When defining the publication, execute sp_addpublication with enabled_for_internet set to TRUE to enable Internet subscriptions.

To publish on the Internet using transactional replication (Transact-SQL)

  • When defining the publication, execute sp_addpublication with enabled_for_internet set to TRUE to enable Internet subscriptions.

To publish on the Internet using merge replication

  • When defining the publication, execute sp_addmergepublication with enabled_for_internet set to TRUE to enable Internet subscriptions.