Skip to Content

Finding source . and its definitions and subscriptions for a replication thread

Hi all,

Can some help me with below:

Finding source <Servername>.<DatabaseName> and its definitions and subscriptions for a replication thread.

Example: I f I have below details -

Spid Name State Info
---- ---------- -------------------- ----------------------------------------
373 DSI EXEC Awaiting Command 591(1) sserver01.mydb
157 DSI Awaiting Message 591 sserver01.mydb
235 DIST Awaiting Wakeup 591 sserver01.mydb
332 SQT Awaiting Wakeup 591:1 DIST sserver01.mydb
11 SQM Awaiting Message 591:1 sserver01.mydb
10 SQM Awaiting Message 591:0 sserver01.mydb

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 05, 2017 at 03:02 PM

    Take a look at this thread: http://nntp-archive.sybase.com/nntp-archive/action/article/%3C4ab748b7.951.1681692777@sybase.com%3E

    While I can't vouch for the up-to-date accuracy of the 4-way UNION, SRS still functions as explained in the thread.

    As for the 4-way UNION ... I'd suggest reviewing the source code of the various rs_help* stored procs (found in the RSSD) and then update the 4-way UNION as you see fit.

    Add comment
    10|10000 characters needed characters exceeded