Does select @@IDENTITY work with version 8.0.02 ?
IT returns "2" every single time.
All I want to do is get the last inserted id from a sequence.
Suggestions?
--
With best regards,
Mike Fahey - Systems Administration
********************************************************************
ENTER.NET - "The Road to the Internet Starts Here!" (tm)
(610) 437-2221 * http://www.enter.net/ * email:support@enter.net
********************************************************************