Posted by David Portas on 09/20/05 00:21

SELECT IDENT_CURRENT('table_name') ;

--
David Portas
SQL Server MVP
--


"trint" <trinity.smith@gmail.com> wrote in message
news:1127164340.720014.70160@g14g2000cwa.googlegroups.com...
> Ok,
> I just need to know how to get the last record inserted by the highest
> IDENTITY number. Even if the computer was rebooted and it was two
> weeks ago. (Does not have to do with the session).
> Any help is appreciated.
> Thanks,
> Trint
>

[Back to original message]