Post reply

Does anyone have any script to view the creation date of an object in Transaction Replication in SQL 2008 R2, example an article (table)

  • June 24, 2013 at 7:10 am

    #276641

    Hello,

    Does anyone have any script to view the creation date of an object in Transaction Replication in SQL 2008 R2, example an article (table)

    Thank you all in advance

  • June 24, 2013 at 7:17 am

    #1626772

    Jose do you mean object creation/modification, like what is available in sys.objects?

    SELECT

    name,

    create_date,

    modify_date

    FROM sys.objects

    ORDER BY

    modify_date DESC

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 24, 2013 at 7:38 am

    #1626777

    Thanks, already gives the information I need

  • June 24, 2013 at 7:46 am

    #1626783

    Hello

    But what I really wanted to know was the historic modification of that object (table), ie know when that object had been added to the publication. With the parameter sys.objects is_published says if this active = 1 or not = 0

    Thanks

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

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