Thomas Abraham (4/24/2012)
I think if you give it some thought, this feature behaves as you would design it. The defaults seem the way I would hope they would - for a pleasant change.
Exactly. I heard of sequences at Dev Connections last month, and immediately thought of some "gotchas" that might make them somewhat difficult to work with. So I wrote some tests, whence came these questions (there's one more in the sequence by the way ; )
Every test I tried worked. Essentially, from what I could tell, you have to ignore the defaults or deliberately do something odd to break sequences in SQL 2012.
So (and I don't say this very often) Bravo, Microsoft!