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 |
|
ds9
Starting Member
38 Posts |
 Posted - 2007-05-15 : 14:00:48
|
| Hi pplI have a DTS that is loading 6 text files into respective tables. Before loading this files the tables are emptied using SQL tasks with the following code:DELETEFROM Table1WHERE (OMC=?)OMC is a PK from table1 and ? is a parameter within the DTS. Occasionally the system hangs executing these delete statements for one of the tables (not always the same!)I’m forced to reboot and then DB goes trough a recovery process.Any idea what might be wrong? Thanks in advance |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-15 : 15:00:52
|
| Can't tell without details. What you can do is setup trace with profiler. |
 |
|
|
|
|
|
Server hangs