Toreador (5/1/2012)
Does anyone have any suggestions for possible uses for sequences? Once upon a time I'd have used them for populating primary keys instead of using identities (ie the way I used to in Oracle). But now that we have the Output clause to easily read back the generated values there doesn't seem much advantage in using a sequence instead.
a loosely coupled multi-sql server system could use these....
define the sequence on each server in a way that they never collide. Then you could write your own "merge" code to replicate changes in the manner you describe.
Other than something like that.... no clue... personally I prefer identities.