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.
Loading User Information from Channel 9
Something went wrong getting user information from Channel 9
Loading User Information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
JChung2006 wrote:SET NOCOUNT ON causes stored procedures to return an int value. Try SET NOCOUNT OFF in your stored procedure.