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.
| Author |
Topic |
|
LLatinsky
Starting Member
38 Posts |
 Posted - 2005-05-03 : 17:28:27
|
| Hello. I am not familiar with replication but I need to programmatically find out by querying the sysprocesses table which spids are running replication. Right now in the program_name field I can see a spid running a program named 'Replication Merge History'. Also, there is a bunch of spids where program_name consists of dash-delimited concatenated strings with pubservername-dbname-dbname-pub-subscribername-4.Which tables do I need to query to dynamically concatenate those parts together to use them as a program_name, or maybe there's another table that will allow me to find a link between a spid and replication.Thank you |
|
|
LLatinsky
Starting Member
38 Posts |
Posted - 2005-05-03 : 17:33:56
|
| Never mind. I found the MSmerge_agents table that has the program name for the agent.Thank you |
 |
|
|
|
|
|
which processes are running merge replication