求：本地订阅已存在、却不显示。解决办法

Question

分发服务器和 发布服务器是一个、 为什么在订阅服务器上看不到呢？  我不会在分发服务器上看 订阅我没改过计算机名我看了 一下 发布服务器上的 MSsubscriptions， 新建订阅的时候、是不是会把订阅信息写到发布分发服务器的 MSsubscriptions 这个里面呢
3 0 ac 3 1 -1 virtual 0 1 3 0x0000006300000195001F 1 1 2011-11-01 11:27:03.783 1 7 0 0x0000006300000195001F 0x0000006300000195001F
3 0 ac 3 1 -2 virtual 0 1 3 0x0000006300000195001F 1 1 2011-11-01 11:27:03.783 1 8 0 0x0000006300000195001F 0x0000006300000195001F
3 0 ac 3 1 2 ac 0 1 3 0x0000006300000195001F 1 1 2011-11-01 11:27:03.783 1 9 0 0x0000006300000195001F 0x0000006300000195001F

Answer 1

http://msdn.microsoft.com/zh-cn/library/ms147306.aspx

Answer 2

-- 只能在分发服务器上执行-- 切换到分发数据库
USE Distribution
GOWITH
PUB AS(
-- 此部分为发布及发布表信息
SELECT
publication_id = PUB.publication_id,
publication_name = PUB.publication,
publication_type = PUB.publication_type, PUB.publisher_id,
publisher_database = PUB.publisher_db, article_id = ART.article_id,
publisher_schema = ART.source_owner,
publisher_table = ART.source_object,
subscriber_schema = ART.destination_owner,
subscriber_table = ART.destination_object
FROM dbo.MSpublications PUB
INNER JOIN dbo.MsArticles ART
ON PUB.publication_id = ART.publication_id
),
SUB_TS AS(
-- 此部分为事务和快照复制的信息
SELECT
PUB.publication_id,
PUB.publication_name,
PUB.publication_type, PUB.publisher_id,
PUB.publisher_database,
PUB.publisher_schema,
PUB.publisher_table, SUB.subscription_type,
SUB.subscriber_id,
subscriber_database = SUB.subscriber_db,
PUB.subscriber_schema,
PUB.subscriber_table
FROM PUB
INNER JOIN dbo.MSsubscriptions SUB
ON PUB.publication_id = SUB.publication_id
AND PUB.article_id = SUB.article_id
),
SUB_M AS(
-- 此部分为合并复制的信息
SELECT
PUB.publication_id,
PUB.publication_name,
PUB.publication_type, PUB.publisher_id,
PUB.publisher_database,
PUB.publisher_schema,
PUB.publisher_table, SUB.subscription_type,
SUB.subscriber_id,
subscriber_database = SUB.subscriber_db,
PUB.subscriber_schema,
PUB.subscriber_table
FROM PUB
INNER JOIN dbo.MSmerge_subscriptions SUB
ON PUB.publication_id = SUB.publication_id
),
REPL AS(
SELECT * FROM SUB_TS
UNION ALL
SELECT * FROM SUB_M
),
REPL_RE AS(
SELECT
REPL.publication_id,
REPL.publication_name,
REPL.publication_type, publisher_server = PSRV.name,
REPL.publisher_database,
REPL.publisher_schema,
REPL.publisher_table, REPL.subscription_type,
subscriber_server = SSRV.name, 
REPL.subscriber_database,
REPL.subscriber_schema,
REPL.subscriber_table, distributor_server = CONVERT(sysname, SERVERPROPERTY(N'ServerName'))
FROM REPL
INNER JOIN sys.servers PSRV
ON REPL.publisher_id = PSRV.server_id
INNER JOIN sys.servers SSRV
ON REPL.subscriber_id = SSRV.server_id
)
SELECT * FROM REPL_RE
ORDER BY publisher_server, publisher_database, publisher_schema, publisher_table

Answer 3

刷新了也没有用、还是看不到。图片中 KAKA 的 本地订阅创建成功却不显示、 在BUFENG中的本地发布可以看到了

Answer 4

sql server有时就是这么怪的,建议把整条复制删除/重建.