<div>
Can we see some code? &nbsp;VB and T-SQL would be handy<br />
<br />
Dave
</div>


Can we see some code?  VB and T-SQL would be handy

Dave

<div>
I assume all you need to do is to add the following line to the procedure:<br />
<br />
CREATE PROCEDURE yourproc<br />
AS<br />
SET NOCOUNT ON &nbsp; &nbsp; &nbsp; --- add this line<br />
... here comes the rest of your proc code<br />

</div>


I assume all you need to do is to add the following line to the procedure:

CREATE PROCEDURE yourproc
AS
SET NOCOUNT ON       --- add this line
... here comes the rest of your proc code


<div>
found it: SET NOCOUNT ON<br />
<br />
<br />
There were 2 sets of select statements.
</div>


found it: SET NOCOUNT ON


There were 2 sets of select statements.

<div>
<div class="content wysiwyg-content">
VB 6.0; SQL Server 2000<br />
<br />
A stored procedure runs perfectly well from SQL Query Analyzer. However, from VB, it won't return anything. If I comment the SQL totally from stored procedure and replace it with 'hello', it returns 'hello' to VB. The parameters are OK. <br />

</div>
</div>


VB 6.0; SQL Server 2000

A stored procedure runs perfectly well from SQL Query Analyzer. However, from VB, it won't return anything. If I comment the SQL totally from stored procedure and replace it with 'hello', it returns 'hello' to VB. The parameters are OK. 


Stored procedure won't return to VB

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.