I am sure a few of you have had this issue so I wrote a script that alters all Identity columns in a DB to NOT FOR REPLICATION :

exec sp_configure 'allow update',1
Reconfigure with Override
go

use CDS
-- exec DBA_RestoreDBFromFile 'CDS','\\chpsql01\SQLBackup\Production\CHPSQL01_CD S_04_May_2004_1326Hrs.bak'

DECLARE @lname varchar(20)
DECLARE @id int
DECLARE @Column_name varchar(20)
DECLARE @cmd as varchar(400)

DECLARE x_cursor CURSOR FOR
select a.name,a.id from cds..sysobjects as a where xtype = 'U' and name not in ('bf4dparticipant','dtproperties')
ORDER BY a.name

OPEN x_cursor

FETCH NEXT FROM x_cursor INTO @lname, @id

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
update syscolumns set colstat = colstat | 0x0008
where colstat = 0x0001 -- is identity
and colstat & 0x0008 = 0 -- no 'not for repl'
and id = @id

-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM x_cursor INTO @lname, @id
END

CLOSE x_cursor
DEALLOCATE x_cursor
go
exec sp_configure 'allow update',0
Reconfigure with Override