拓冰网站定制 
--table是否在使用replicate功能 publication: select name from sys.tables where is_published1 order by 1 subscription: SELECT distinct [publisher] ,[publisher_db] ,[publication] ,[article] FROM [db_name].[dbo].[MSreplication_objects] where articletable_name order by 4 SQL Server 判断table是否在使用replicate功能
--table是否在使用replicate功能 publication: select name from sys.tables where is_published1 order by 1 subscription: SELECT distinct [publisher] ,[publisher_db] ,[publication] ,[article] FROM [db_name].[dbo].[MSreplication_objects] where articletable_name order by 4