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-04-06 : 09:31:55
|
writes "I've written two stored procedures:
sp_InsertInfo
sp_BatchInsertInfo
sp_InsertInfo basically does a single insert into a table.
sp_BatchInsertInfo has a nested loop that calls sp_InsertInfo:
select top 1 ....
while(@@rowcount=1)
BEGIN
select top 1 ....
while(@@rowcount=1)
BEGIN
exec sp_InsertInfo
select top 1 ....
END
select top 1 ....
END
When I execute sp_BatchInsertInfo in QueryAnalyser, it runs through correctly populating the table that sp_InsertInfo inserts into.
When I run this from an ASP page, the sproc stops only part way through the execution. I'm guessing that this is a timeout issue? How can I fix it?
One thing to note is this... if I strip the code from sp_InsertInfo and insert it directly into sp_BatchInsertInfo (instead of calling a stored procedure, run the code directly) there are no problems.
What's going on?
Thanks,
Joel" |
|
|
|
|
|
Stored Procedure Timeout