Merge Replication Subscription Create Date

  • I have a database here with a number of local subscriptions,

    a couple of them are causing a few problems.

    Is there a way to determine what date and time a local subscription to merge replication was created ?



  • Have you tried rooting around in the msdb database? Nothing specific comes to mind, other than that I think a transaction is created for each subscription in the db. that implies that the earliest transaction, if it's not overwritten and has a time stamp, may provide an answer to your question.

  • Thanks for that will have a look around msdb.

    Does anyone know of any good db documentation for msdb?

    i have looked around BOL and google but can't seem to find any documentation outlining exactly what each table/view etc. does..

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply