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 |
|
nvakeel
Yak Posting Veteran
52 Posts |
 Posted - 2008-01-28 : 11:21:18
|
| I have a stored Proc, which takes 30 min for execution. If I execute it twice it runs properly but when i do the same the third time, it gets stuck.. any reasoning for this..I am using Insert into statements a lot here... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-28 : 12:09:46
|
That might be the problem?Do the table inserted into have a primary key with uniqueidentifier?How many millions of records are there in the table?
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
nvakeel
Yak Posting Veteran
52 Posts |
Posted - 2008-01-28 : 13:02:20
|
| roughly around 1.5million records bein inserted into the tables. It runs perfectly once or twice but If I do the same then it will not respond and throws an error of deadlock.. |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-31 : 13:47:37
|
| Can you post the code?Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Problem with Strored Proc