Microsoft – SQL Server – Replication – Is database Configured

Special thanks To Greg Y (MSFT) a community moderator @ http://social.msdn.microsoft.com/ on this one.

v2008 and above:

      select name, category
      from   sys.databases

v2005

       select 
                  name
                , is_published
                , is_subscribed
                , is_merge_published

       from   sys.databases

 

References:

1) Invalid object name ‘dbo.sysmergesubscriptions’. error ( Greg Y [MSFT])

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/272a2274-8085-4f57-a6f8-d54c203bc4ce

2)  sys.databases
http://msdn.microsoft.com/en-us/library/ms179900(v=sql.90).aspx

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s