求：本地订阅已存在、却不显示。解决办法
订阅服务器上 创建完订阅不显示、 在创建 说已存在、实在是搞不定了。
订阅信息在系统数据库 什么表里存储啊。怎么找、   QQ：179299180
网上说的基本都试过了、不好用。

------解决方案--------------------
http://msdn.microsoft.com/zh-cn/library/ms147306.aspx
------解决方案--------------------
-- 只能在分发服务器上执行

-- 切换到分发数据库

USE Distribution

GO



WITH

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,

		RE