Perry,

Just to let you know...

If you require the same identity generation semantics as previous versions of SQL Server there are two options available:

• Use trace flag 272

o This will cause a log record to be generated for each generated identity value. The performance of identity generation may be impacted by turning on this trace flag.

• Use a sequence generator with the NO CACHE setting(http://msdn.microsoft.com/en-us/library/ff878091.aspx)

o This will cause a log record to be generated for each generated sequence value. Note that the performance of sequence value generation may be impacted by using NO CACHE.

o Example:

CREATE SEQUENCE s1 AS INT START WITH 1 NO CACHE;

CREATE TABLE t1 (Id INT PRIMARY KEY DEFAULT NEXT VALUE FOR s1, col INT NOT NULL);