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 |
|
boyzone007
Starting Member
4 Posts |
 Posted - 2009-06-11 : 03:41:52
|
| HiI need help on following scenario. I have created one store procedure, which do some transaction & return one record set.In SQL query analyzer I took one temp table & added around 300 records in that. I am calling this SPROC in the loop for all the records in temp table. I included this loop in BEGIN TRANSACTION. After processing around 60-70 records This SPROC does not return records set, not even give any exception, not even halt. It keep processing for all the remaining records in the temp table. I can check in the db, processing is going on & records are getting updated there.But why after 50-60 records SPROC is not able to return records set.And if I do not use BEGIN TRANSACTION, it works fine. How come using TRANSACTION, make this not work.Urgent Help.... Amit |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-11 : 03:48:04
|
You are calling the SPROC from an application?Have you checked the COMMANDTIMEOUT parameter value in your connection string?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
boyzone007
Starting Member
4 Posts |
Posted - 2009-06-11 : 03:52:30
|
| Yes timeout is not an issue. Because process is still running, & it get completed as well. I am calling this from C# application. I tried the same from SQL query analyzer as well. same issue.This sproc is calling lot of other SPROC's, updating lot of db tables. Triggers will also get involved. Is there any restriction of log for this? |
|
|
|
|
|
|
Problem while using Transaction