@Gift: Thanks Gift, but I was trying to emphasize that the database was a legacy (SQL2000) database and so "SCOPE_IDENTYTY()" wasn't available (AFAIK...) We're now on SQL2005 so things are a bit better now.
Actually there was Scope_Identity in 2000 may be your application just did not use it.
http://msdn.microsoft.com/en-us/library/aa259185(SQL.80).aspx
Kind regards,
Gift Peddie