sqlsvr schrieb am 20.12.2010 um 16:41 (-0000):

> WOW, So I have to create a trigger for each table which adds another
> layer of maintenance issues?

Script kiddies and database grand viziers have been known to avoid those
by resorting to, say, DDL templates. Not sure what category you belong
to. :-)

> In all other DBMS I used, you can simply declare a field as a identity
> field and it will do the rest.

But sometimes they don't have sequences, which come in handy when you
need the flexibility.

Michael