Run-time Error '3704' Operation Is Not Allowed When The Object Is Closed In Vb6 While Using Sp Using Temp Tables

I am using the Stored procedure 'sp_Missingdata' to get the data and to display in the MSFlexGrid, But i am getting the error as - run-time error '3704' operation is not allowed wh

Solution 1:

You need SET NOCOUNT ON in the body of the procedure, as the first line, not outside of the declaration, that only applies when altering the stored proc.