I've setup a method that I would like to get the last identity of a table NOT the last identity overall. If working with SQL 2000+ I can use:

Code:
IDENT_CURRENT('<TableName>')
This would return me the last identity inserted on the named table. Is there an equivalent using M$ Jet 4+?

At the moment I am using the following:
Code:
SELECT @@Identity FROM <TableName>  AS UID
But this will only give me the LAST INSERTED ID overall in the database.

Regards

John