• I think what he's looking for is related to

    SET IDENTITY_INSERT DBO.YOURTABLE ON