• Check the initial value before the insert:

    DBCC CHECKIDENT('myTable',NORESEED)

    If it is not 1, your creation script has initial value that is not 1.

    To reset identity to start from 1 use this:

    DBCC CHECKIDENT('myTable',RESEED,0)

    But it is better to fix the creation script.

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths