none
Can any one can tell about sp_showlineage RRS feed

Answers

  • Hi Kumar,

    For the definition of this stored procedure to track the row version, please have a look at its DDL structure: sys.sp_showlineage.

    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, January 30, 2012 7:47 AM
    Tuesday, January 24, 2012 6:08 AM
  • Version number is the version of the row.

    For instance, if the row has been updated 3 times it will have a version number of 4.

    You can simulate this in a test environment.


    Brandon Williams (blog | twitter)
    • Marked as answer by Stephanie Lv Monday, January 30, 2012 7:47 AM
    Tuesday, January 24, 2012 9:35 PM
    Moderator

All replies

  • As Hilary mentions here, it is used to display history and information about a row in a Merge article.
    Brandon Williams (blog | twitter)
    Monday, January 23, 2012 4:42 AM
    Moderator
  • Thank you for your reply, but I need some more details how it tracks the row change, like version number etc..

    Thanks in advance.

    Thanks

    Kumar


    Kumar
    Monday, January 23, 2012 11:37 PM
  • Hi Kumar,

    For the definition of this stored procedure to track the row version, please have a look at its DDL structure: sys.sp_showlineage.

    Stephanie Lv

    TechNet Community Support

    • Marked as answer by Stephanie Lv Monday, January 30, 2012 7:47 AM
    Tuesday, January 24, 2012 6:08 AM
  • Version number is the version of the row.

    For instance, if the row has been updated 3 times it will have a version number of 4.

    You can simulate this in a test environment.


    Brandon Williams (blog | twitter)
    • Marked as answer by Stephanie Lv Monday, January 30, 2012 7:47 AM
    Tuesday, January 24, 2012 9:35 PM
    Moderator