Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PankajBhasin
Starting Member
1 Post |
 Posted - 2001-06-29 : 15:19:24
|
| We run some stored procs, some of them are all fine but a few of them when executed in a loop would somehow not result for no reason. See following declare @lngVal integerSelect @lngVal = 1while @lngVal <100000beginprint "hi"Exec -----endThe problem SPs will have on average one in 200 execution return nothing, so I would see following output in query analyser.hihiFron end system recieves this as no error and when we try to fetch ADO recordset it gives error "Operation is not Allowed when object is closed.". This is documented in ADO but in our case is comming because of this sql issue. |
|
|
|
|
|
Operation is not Allowed when object is closed