Seriously... you're hearing us, but you're not listening. Took me less than 10 seconds to look it up on MSDN. It's not that hard. You open a browser.... type msdn.microsoft.com into the address bar, enter "scope_identity" into the search box. It'll even give you assistance with "scope_identity" "scope_identity()" and "scope_identity sql" as suggestions... pick any of them... even with just "scope_identity" you get results. the first of which is this link: http://msdn.microsoft.com/en-us/library/ms190315.aspx and as you can see... it is a FUNCTION ... so you have to call it as "scope_identity()"

MSDN is your friend. Learn to use it.

-tg