anand,

It's probably PRINT statements in there, or ROWCOUNTS popping into the
results. Comment out all PRINT statements, and SET NOCOUNT ON at the top of
the proc.

Regards,
D. Patrick Hoerter


anand verma wrote in message <38c63f61$1@news.devx.com>...
>
>problem : executing heavy procs having multiple select , update and delete
>statesment with ado execute method or by command
>method i get message recordset close runtime error. eithe it have a final
>select statement for generating reports.
>
>I got help for setting querytimeout value so i set it to 0
>and i do execute those procs which have only select statements
>of assignment and 'if conditions' and one final select statment
>then it executes properly
>
>