Trouble getting last insert id in Sql Server Using Scope_Identity always returns zero

Printable View