>The numeric IDENTIFY column doesn't require any additional functions to generate next ID. The uniqueidentifier column (UUID) can use NEWID() as default value.
>
>I use IDENTITY in all new development. I may use "manual" approach for compatibility with some existing system.

Great, this is what I thought.