Welcome to SSQA.net Sign in | Join | Help

SQL Server Replication (SSQA.net)

Another methodology to distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet.
Replication FAQ series - Which objects in the database are published?

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published
from sys.tables where is_published = 1 or is_merge_published = 1 or is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.procedures where is_schema_published = 1
union
select name as published_object, schema_id, 0, 0, is_schema_published
from sys.views where is_schema_published = 1

Posted: Tuesday, December 11, 2007 4:47 AM by SQL Master

Comments

Other SQL Server Blogs around the Web said:

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published

# December 11, 2007 4:48 AM

SSQA.net - SqlServer-QA.net said:

select name as published_object, schema_id, is_published as is_tran_published, is_merge_published, is_schema_published

# December 11, 2007 5:50 AM
Anonymous comments are disabled