Hi, everybody!

What is best way to retrieve NewID on a SQL Table:
* Identity Fields?
* A Meta-Table with the last ID generated for each one of my tables?
* A SELECT MAX(ID) Statement?

Or there's some other?

I'm developing a N-Tier application and I'm using ADO RecordSets to pass data through layers...

Any information about this issue is of extreme importance for me.

Thanks in Advance!