Merge Replication Subscription Create Date

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 8, 2008 at 5:01 am

  #185197

  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 ?

  Thanks,

  Steve.

• steve smith-401573

  SSChampion

  Points: 10889

  More actions

  May 30, 2008 at 10:27 am

  #822453

  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.

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  May 30, 2008 at 10:37 am

  #822454

  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..