JChung2006 wrote:
SET NOCOUNT ON causes stored procedures to return an int value.  Try SET NOCOUNT OFF in your stored procedure.


But Its not set ON. Its off.

Not sure why it keeps doing it.