SET NOCOUNT Error in handling SQL call after upgrade
SQL Server Configuration has an option called, appropriately, user options, which can be set using the sp_configure system stored procedure.  I wrote a blog post on SQL Server Science showing how to inspect and set the user options.

In brief, you can get the "config value" from the old server, using this:

EXEC sys.sp_configure 'user options';


Then, set the new server to use the same options via this:

EXEC sys.sp_configure 'user options', &lt;config value&gt;;
RECONFIGURE


(replace the &lt;config value&gt; with the value from the old server).