Thanks for all the suggestions, I will have a deeper dive into the stored proc option and ensure I have the $identity included...

sounds like these will get me going .