is a subscriber

[Darin]

We have customers that don't use replication, and some that use merge
replication.

I need a command able to be executed in a stored procedure that will
tell me is this SQL Server is a subscriber in a replication environment.
that is all i need to know. Something like:

if issubscriber(SQL_SERVER_NAME)=1
begin
do something for the subscriber
end
else
begin
do something different for publisher OR non-replicated
end

Darin

*** Sent via Developersdex http://www.developersdex.com ***