It's that easy. Just use a column list in the INSERT INTO statement for both sides to directly control who goes in what position.
IE:
CREATE TABLE #tester
(IdCol INT IDENTITY( 1, 1), SomeStuff VARCHAR(5))
SET IDENTITY_INSERT #tester ON
INSERT INTO #tester (IdCol, SomeStuff)
VALUES ( 1, 'abc')
INSERT INTO #tester (IdCol, SomeStuff)
VALUES ( 2, 'dbc')
INSERT INTO #tester (IdCol, SomeStuff)
VALUES ( 3, 'ebc')
SELECT * FROM #tester
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA