>It appears to be something with the way SQL works and the stored Procedure. When I run the stored procedure directly in SSMS I can see the value of the parameter in addition to the return value of 0, but in code I can't get that returned. I eventually tried using just native dot net stuff without the mm layer and I get the same thing so ruled out any mm implementation of it. I am really not sure right now what is causing the issue and I am hoping maybe some others from the SQL group will see something about the way the SP is constructed.

Hi Tim,

It could be the SP or the code used to retrieve the OUTPUT parameter ... it's hard to say because you guys have posted a bunch of different versions of SP and code in this thread, and I can't say for sure anymore which is the final version that isn't working for you.

If you can post it again, SP and code, then maybe something will jump out at me ...

EDIT ... what I mean, if it wasn't clear, is to post the native .NET code, not the MM-based code.

~~Bonnie