I failed to catch the follow-up post about there being an identity column involved. Sorry!
Note to all - don't answer forum posts while on a cruise!! :blink:
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service