I'm trying to execute a stored procedure which involves a temp table. I'm getting no errors in the code, but no resultset either.
The whole process worked fine with SQL Server 7.0, but not 2000. Anyone run into this?

thanks.
Melissa Mussitsch
ANSYS - IT

Do you have SET NOCOUNT ON inside your sproc (prior to doing the insert into the temp table)? Otherwise the "xx records affected" message is being returned, and placed into the recordset object. You can SET NOCOUNT ON after you have done anything that returns "xx records affected".

That was exactly what I needed to do!

Thanks!