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 |
|
TheLearner
Starting Member
1 Post |
 Posted - 2004-04-15 : 05:45:55
|
| I have a stored procedure which uses cursors that loops thru the records in a particular table,and inserts into 6 different tables .There are 4-5 conditions also in between to cehck the validatity of the fields.when i run the procedure from my CFM page it Hangs my sql server .What should i do for immediately unlocking it.Any suggestions? |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-04-15 : 07:14:56
|
| Eliminate the cursors!....post the code, sample data, expected results and we may be able to advise corrective surgery.their performance is p*sspoor....search here for many horror stories.For locking problems....search here for advice on using SQL Profiler. |
 |
|
|
cas_o
Posting Yak Master
154 Posts |
Posted - 2004-04-15 : 09:16:45
|
| Post the code for us to see, are you sure you havn't got a permanent loop that never exits maybe? a common problem with itterative code.;-] |
|
|
|
|
|
|
SQL server is holding Locks