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
bibi92Asked:
Who is Participating?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.