此数据库未启用发布

USE GlobalSales; GO EXEC sp_helpmergepublication GlobalSales EXEC sp_helppublication GlobalSales EXEC sp_helppublication_snapshot GlobalSales GO -- Execute this batch at the Publisher. DECLARE @publication AS sysname; DECLARE @subscriptionDB AS sysname; DECLARE @subscriber AS sysname; SET @publication = N'Mitjab-Notebook\SQL2008'; SET @subscriptionDB = N'GlobalSales'; SET @subscriber = N'SERVER\SQL2008'; -- At the Publisher, register the subscription, using the defaults. USE [GlobalSales] EXEC sp_addsubscription @publication = @publication, @subscriber = @subscriber, @destination_db = @subscriptionDB, @subscription_type = N'pull', @update_mode = N'failover'; GO 

但我得到:

消息14013,级别16,状态1,过程sp_MSrepl_helppublication_snapshot,第29行此数据库未启用发布。

使用Express Edition不能复制(作为发布者)

因此,然后启用发布,或者在启用发布的数据库上运行。 查看复制选项以configuration发布和分发。