• Hi lokesh,

    as you TRUNCATE the table then identity will be reset to 1 and now the ident value after a insert statement will be 1..

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/