How to query list of subscriptions and articles?

How to query list of subscriptions and articles?

In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) Yes, there are easier ways to query from Distributor but I need a query from Publisher side. Found this sys proc, not sure if it is correct.

How to check for subscriptions in a database?

You can use this view to check for active subscriptions in the server or a specified database, or to check for a specified server principal. ID of a subscription. ID of the database in which the notification query was executed. This database stores information related to this subscription.

Where are replication tables in the subscription database?

Scroll down to the section for “Replication Tables in the Subscription Database” and you will find the tables for publications, subscriptions, schemas, articles and columns. For those needing a quick snippet…

When to fire a subscription in SQL Server?

However, if a change that invalidates the subscription occurs after the specified time-out, but before the subscription is fired, SQL Server ensures that firing occurs at the time that the change was made. Indicates the status of the subscription. See the table under remarks for the list of codes.

Where are the subscription options in SQL Server?

The Subscription Options page allows you to set a number of options that apply to all subscriptions. The options differ depending on the type of publication. The Publication Access List page allows you to specify which logins and groups can access a publication.

How to look up instance names of publishers and subscriptions?

I have found tables that contain the names of the publication database and subscription database (MSsubscriptions). However, although publisher_id and subscriber_id are listed as fields, I don’t see how I can use that to get the names of the SQL instances.

How to view and modify publication properties in SQL Server?

This topic describes how to view and modify publication properties in SQL Server by using SQL Server Management Studio, Transact-SQL, or Replication Management Objects (RMO). Some properties cannot be modified after a publication has been created, and others cannot be modified if there are subscriptions to the publication.

Is there easier way to query from distributor?

Yes, there are easier ways to query from Distributor but I need a query from Publisher side. Found this sys proc, not sure if it is correct. Any ideas for better solution? Thanks for contributing an answer to Database Administrators Stack Exchange! Please be sure to answer the question.

Which is Power Query formula language does PBID use?

The syntax may look unfamiliar to you; PBID uses M, the Power Query Formula Language. I hope to do an upcoming tip on using the Power Query Formula Language, but for now, you can see in the below illustration the language specifies the data source connection and then requests the data from the SalesOrderHeader.

Where do I find the get data button in PBID?

When you open PBID, the start screen, as shown below, allows you to start the query process via clicking on Get Data. Alternately, if you bypass the start screen, you can click on the Get Data button in the ribbon.

How to find out, from the subscriber?

My database is a subscriber to one or more publishers. But I don’t have access to the publisher or distributor. My question is, which views (or system tables, DMV’s or stored procs, etc) are available on the subscriber so that I can use T-SQL to identify which tables are populated via replication or replication subscribers?

How to get list of all SSRs subscriptions with parameters?

I’ve be searching and trying for hours to get a query that gives me all current subscriptions from an SSRS serv with parameters and their values, so that they can be recreated on a new server (after pruning). For example a simple report might be HoursByDepartment that takes three params:

What does the Aq _ queue _ tables view do?

V$AQ_BACKGROUND_COORDINATOR: Performance Statistics for AQ’s Master Background Coordinator Process (AQPC) The DBA_QUEUE_TABLES view contains information about the owner instance for a queue table. A queue table can contain multiple queues. In this case, each queue in a queue table has the same owner instance as the queue table.

What is the Aq$ Internet _ users view on Oracle Database?

The AQ$INTERNET_USERS view provides information about the agents registered for Internet access to Oracle Database Advanced Queuing. It also provides the list of database users that each Internet agent maps to. Indicates whether this agent is allowed to access Oracle Database Advanced Queuing through HTTP ( YES or NO)