<div>
Tim,<br />
<br />
&gt;&gt;Or you change the stored procedure that you are calling and add &quot;SET NOCOUNT OFF&quot; &lt;&lt;<br />
I think you mean SET NOCOUNT ON. &nbsp;Otherwise we have the default and messages will be displayed. &nbsp;It is after all a double-negative :)
</div>


Tim,

>>Or you change the stored procedure that you are calling and add "SET NOCOUNT OFF" <<
I think you mean SET NOCOUNT ON.  Otherwise we have the default and messages will be displayed.  It is after all a double-negative :)

<div>
acperkins, it was hot and minutes before I was leaving work. That's my excuse anyway, the thought was there.
</div>


acperkins, it was hot and minutes before I was leaving work. That's my excuse anyway, the thought was there.

<div>
&gt;&gt;That's my excuse anyway, the thought was there.&lt;&lt;<br />
Most definitely, did not mean to steal your thunder, I just wish Microsoft had called it SET COUNT OFF :)<br />
<br />
Anthony
</div>


>>That's my excuse anyway, the thought was there.<<
Most definitely, did not mean to steal your thunder, I just wish Microsoft had called it SET COUNT OFF :)

Anthony

<div>
<div class="content wysiwyg-content">
Everytime I use the SalesLogix client to connect to the database I get a &quot;Cannot perform this operation on a closed dataset&quot;<br />
<br />
Any ideas on how to get the client to connect to the database.<br />
<br />
We are using Windows 2000 server and SQL 2000<br />
<br />

</div>
</div>


Everytime I use the SalesLogix client to connect to the database I get a "Cannot perform this operation on a closed dataset"

Any ideas on how to get the client to connect to the database.

We are using Windows 2000 server and SQL 2000



Closed dataset error

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.