Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 How to identify machines that replicate...?

Author  Topic 

dhw
Constraint Violating Yak Guru

332 Posts

Posted - 2003-03-27 : 17:19:22
Hello..

We have publichation using transactional replication set up to allow anonymous pull subscriptions via FTP. Is there any way do identify the unique machine/device that is pulling the data? Would some of this be stored in one of the replication tables or logs?

thanks...dw

samsekar
Constraint Violating Yak Guru

437 Posts

Posted - 2003-03-31 : 04:22:05
HTH..
I haven't tried this before..

sp_helpsubscriberinfo
sp_helpsubscription

Sekar
~~~~
Success is not a destination that you ever reach. Success is the quality of your journey.
Go to Top of Page

dhw
Constraint Violating Yak Guru

332 Posts

Posted - 2003-03-31 : 10:55:09
Thanks for the suggestion. I'll give those stored procs a try.

dw

Go to Top of Page
   

- Advertisement -