Sql Server : How to query list of subscriptions and Articles (for a given publication) from PublisherMultiple...
If nine coins are tossed, what is the probability that the number of heads is even?
Does the in-code argument passing conventions used on PDP-11's have a name?
How to draw tikz paths composed only of horizontal, vertical and diagonal segments?
Rationale to prefer local variables over instance variables?
Is there a way to find out the age of climbing ropes?
Practical reasons to have both a large police force and bounty hunting network?
A bug in Excel? Conditional formatting for marking duplicates also highlights unique value
How spaceships determine each other mass in space?
Why do we see a rainbow of colors reflected off a CD or DVD?
An Undercover Army
What kind of inflection is occuring in passive vb + かかった?
« Rendre » et « render » (the meaning)
PTIJ: Mordechai mourning
Is divide-by-zero a security vulnerability?
How to concatenate two command in shell
Plagiarism of code by other PhD student
Deal the cards to the players
Can a space-faring robot still function over a billion years?
Are Wave equations equivalent to Maxwell equations in free space?
“I had a flat in the centre of town, but I didn’t like living there, so …”
Being asked to review a paper in conference one has submitted to
Can a Mexican citizen living in US under DACA drive to Canada?
What's the best tool for cutting holes into duct work?
Can an earth elemental drown/bury its opponent underground using earth glide?
Sql Server : How to query list of subscriptions and Articles (for a given publication) from Publisher
Multiple Distributors in SQL Server ReplicationTransactional replication between SQL Server 2014 (Publisher) and SQL Server 2012 (subscriber)sql server replication - how to find and drop subscriptions?how to find the name of the distributor server and publisher server from the subscriber server/subscriber databaseWhy does Publisher need to be able to connect to Remote Distributor?Pausing AlwaysOn Availability Group replication for failoverTwo-step Replication between SQL 2008 and 2017How to Setup a Distributor for Replication on Different Server in 2014How to set up a transactional replication to an Always On Availability Group (AG) with two replicas through connecting to the AG ListenerIssues setting up a publisher for transactional replication on a SQL Server with a custom instance
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.
Remote Distributor model (if it helps)
Thanks,
sql-server sql-server-2014 transactional-replication
asked Nov 13 '18 at 19:51
ToCToC
327314
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
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.
Remote Distributor model (if it helps)
Thanks,
sql-server sql-server-2014 transactional-replication
asked Nov 13 '18 at 19:51
ToCToC
327314
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
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.
Remote Distributor model (if it helps)
Thanks,
sql-server sql-server-2014 transactional-replication
asked Nov 13 '18 at 19:51
ToCToC
327314
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.
Remote Distributor model (if it helps)
Thanks,
sql-server sql-server-2014 transactional-replication
sql-server sql-server-2014 transactional-replication
asked Nov 13 '18 at 19:51
ToCToC
327314
asked Nov 13 '18 at 19:51
ToCToC
327314
asked Nov 13 '18 at 19:51
ToCToC
327314
asked Nov 13 '18 at 19:51
ToCToC
327314
asked Nov 13 '18 at 19:51
ToCToC
327314
327314
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 6 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Found this sys proc, not sure if it is correct.
sp_helpsubscription
Any ideas for better solution?
Thanks,
answered Nov 14 '18 at 22:35
ToCToC
327314
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist
– ToC
Nov 14 '18 at 22:36
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222460%2fsql-server-how-to-query-list-of-subscriptions-and-articles-for-a-given-public%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Found this sys proc, not sure if it is correct.
sp_helpsubscription
Any ideas for better solution?
Thanks,
answered Nov 14 '18 at 22:35
ToCToC
327314
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist
– ToC
Nov 14 '18 at 22:36
add a comment |
Found this sys proc, not sure if it is correct.
sp_helpsubscription
Any ideas for better solution?
Thanks,
answered Nov 14 '18 at 22:35
ToCToC
327314
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist
– ToC
Nov 14 '18 at 22:36
add a comment |
Found this sys proc, not sure if it is correct.
sp_helpsubscription
Any ideas for better solution?
Thanks,
answered Nov 14 '18 at 22:35
ToCToC
327314
Found this sys proc, not sure if it is correct.
sp_helpsubscription
Any ideas for better solution?
Thanks,
answered Nov 14 '18 at 22:35
ToCToC
327314
answered Nov 14 '18 at 22:35
ToCToC
327314
answered Nov 14 '18 at 22:35
ToCToC
327314
answered Nov 14 '18 at 22:35
ToCToC
327314
327314
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist
– ToC
Nov 14 '18 at 22:36
add a comment |
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist
– ToC
Nov 14 '18 at 22:36
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist– ToC
Nov 14 '18 at 22:36
EXEC sp_helpsubscription @publication = 'Publication', @article = 'Table', @found = @DoesSubscriptionAlreadyExist OUTPUT SELECT @DoesSubscriptionAlreadyExist– ToC
Nov 14 '18 at 22:36
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f222460%2fsql-server-how-to-query-list-of-subscriptions-and-articles-for-a-given-public%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
