Beware that if you call scope_identity before the insert you get an error.

"Select @@Scope_Identity" from a new connection in the Query Analyzer generates:

Server: Msg 137, Level 15, State 2, Line...