• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 473
  • Last Modified:

check if a server is distributor or a publisher

Hello,

How can I verify in TSQL if a server is distributor or a publisher?

Thanks

Regards

bibi
0
bibi92
Asked:
bibi92
1 Solution
 
sureshbabukrishCommented:
do you want to know whether the db in sql server is a distributor or publisher?
0
 
Alpesh PatelAssistant ConsultantCommented:
Please see attached screen shot screen shot
0
 
bibi92Author Commented:
Yes I want to  know whether the db in sql server is a distributor or publisher but in T-SQL, I have search system stored procedure but I haven't found.
Thanks
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
Anthony PerkinsCommented:
Your original question had to do with the server and this is how you do it:
SELECT name, is_publisher, is_distributor, is_subscriber
FROM sys.servers
0
 
bibi92Author Commented:
Thanks bibi
0
 
Anthony PerkinsCommented:
In order to know if a particular database is a Publisher, Distributor or Subscriber you can use:
SELECT name, is_published, is_distributor, is_subscribed, is_merge_published
FROM sys.databases
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now