Problem getting results from a temp table

[questhaven]

I'm trying to open a resultset from a stored procedure with ADODB.Recordset.

The stored procedure returns the content of a temp table with a SELECT at the end.

It is working fine inside the query analyzer - but doesnt't return any data when I run the query from an ASP page and try and display the record set.

Does anyone have any idea?

Thanks.

 

[questhaven]

I left SET NOCOUNT ON out of the stored procedure - adding this solved the problem. Thanks anyway!