Replication question

Hi,
How do I know if any database is a publishing database or not?
Same way, how do I know if a particular server is a subscriber or not?
I want to know, the quickest and fastest way to get the publication name
and/or subscription name from the server.
regards
KP
Hi,
U can select for the Sysdatabases table in master database.
In that with the Category column value we can identified whether its
published or subscribe.
Values are
1 = Published.
2 = Subscribed.
4 = Merge Published.
8 = Merge Subscribed.
Herbert
"Krishnaprasad Paralikar" wrote:

> Hi,
> How do I know if any database is a publishing database or not?
> Same way, how do I know if a particular server is a subscriber or not?
> I want to know, the quickest and fastest way to get the publication name
> and/or subscription name from the server.
> regards
> KP
|||Check out DATABASEPROPERTYEX() in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
..
"Herbert" <Herbert@.discussions.microsoft.com> wrote in message
news:2C60C225-68EF-4670-99E4-8817CD2A80B4@.microsoft.com...
Hi,
U can select for the Sysdatabases table in master database.
In that with the Category column value we can identified whether its
published or subscribe.
Values are
1 = Published.
2 = Subscribed.
4 = Merge Published.
8 = Merge Subscribed.
Herbert
"Krishnaprasad Paralikar" wrote:

> Hi,
> How do I know if any database is a publishing database or not?
> Same way, how do I know if a particular server is a subscriber or not?
> I want to know, the quickest and fastest way to get the publication name
> and/or subscription name from the server.
> regards
> KP
sql