This is a legacy database, what is this strange "SCOPE_IDENTYTY()" that you speak of? When I got here three years ago there were no keys.
Scope_Identity returns the last value of your Identity key which may include gaps if there are deletes and aborted transactions.
http://msdn.microsoft.com/en-us/library/ms190315.aspx
Kind regards,
Gift Peddie