SQL Server probably does something similar. So say, SQL Server grabs 100 numbers at a time, if the database shuts down abnormally, then you'll start with the 101st number.

I've got this view defined on two tables, one of which has an identity field that auto increments. There seems to be no way to insert into this view. If I leave the auto-increment field blank it ...

SQL Server has come a long way in the past 5 years, though the history seems to linger. Let's look at the recent history and see what the story is with database vulnerabilities.