• Here is an alternative solution without 'set identity_insert' 😉

    INSERT INTO TEST WITH (KEEPIDENTITY) (Col1)

    SELECT IDENT_CURRENT('Test') FROM OPENROWSET(BULK N'C:\boot.ini', SINGLE_BLOB) AS a