TITLE: New Publication Wizard
------------------------------
SQL Server could not create publication 'CustomerListPublication'.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Invalid object name 'dbo.sysmergepublications'.
Publication 'CustomerListPublication' does not exist.
Changed database context to 'AdventureWorksMobileStaging'. (Microsoft SQL Server, Error: 208)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
今天在用sql server2005创建一个数据发布时,总是碰到上面的这个错误, 在国外网站上找了半天,结果两三行sql语句搞定,真是达人啊
---------------------------
Use [DataBaseName]
EXEC sp_removedbreplication
go
---------------------------
当然,这将会删除这个数据库下的所有发布,运行该命令之前请备份好你的数据发布。