Dariusz Czechowicz (7/7/2008)

---

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