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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-28 : 09:06:23
|
| Ganesh writes "I have written a stored procedure in sql server 2000, which has many lines and "select * from <TABLE" being the last line of it. When this stored procedure is executed from an asp file then i get this error "Object closed. Operation not allowed". Whereas if i split the same stored procedure into two, i.e the first stored proc with all the logics and without the last line "Select * from <TABLE" and second stored procedure just as one line "Select * from <TABLE" then the same asp program (calls made to these 2 stored procs) works fine. I donno whether it is a problem in the stored procedure or in my asp program. If you think it is a problem only in my stored procedure then help me out. But strangely, this unsplit stored procedure and the asp program works fine in my development environment, but not in the production environment, although both the software environment being same. Is any settings i should make in the sql server to make this stored proc work." |
|
|
|
|
|
Select Statement being the last line in a stored procedure