Solved

sql2005: how to find distributor in Query Analyzer in publisher

Posted on 2007-03-27
1
230 Views
Last Modified: 2010-03-19
In sql2005, which sp that I could use to identify which distributor use to connect at my publisher? what is the command need to be run in publsiher to check the current use distributor?
0
Comment
Question by:motioneye
1 Comment
 
LVL 16

Accepted Solution

by:
rboyd56 earned 500 total points
ID: 18800311
sp_helpdistributor will give you information about the dsitributor for a publisher. It is run at the publisher database..
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Date from a string 4 70
MS SQL order by with "over" statement and row_number() 11 52
SQL query to summarize items per month 5 71
SQL query with cast 38 53
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question