Post reply

Merge Replication Subscription Create Date

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

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

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

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

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