Hi,

>when i use command.Execute() to fetch record from sql store proc i get
>recordset.recordcount = -1 , though records are there in recordset.
>Please any one can tell what i need to set first ?

rs.MoveLast() before asking for the reccount should help.

Regards,
Armin