We had a .Net application that kept getting a null reference returned from a stored procedure. Since SCOPE_IDENTITY() was used after the INSERT, we assumed the value was OK until more in-depth debugging pointed to the primary key.

Hopefully, even the simple questions serve a purpose. I'm certainly more cautious about making assumptions while debugging problems.