Hugo Estrada's House of Wonder

These guys will first allow you to insert an identity into a sql server table, and then turn off that power.

SET IDENTITY_INSERT tablename ON
SET IDENTITY_INSERT tablename OFF

bogus example:

SET IDENTITY_INSERT funkyFooTable ON

insert into funkyFooTable
(id, funkyBarColumn) values (31415, 'Tasty pie....')

SET IDENTITY_INSERT funkyFooTable OFF

And here is the source of this tidbit with a better explanation on how to use it. Thanks, Ben Nadel!
http://www.bennadel.com/blog/24-Turning-Off-and-On-Identity-Column-in-SQ...