If you are using SQL 7 and triggers be careful, as you the identity gets over written

Simon Sabin

Co-author of SQL Server 2000 XML Distilled

http://www.amazon.co.uk/exec/obidos/ASIN/1904347088