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 |
|
scottjohniec
Starting Member
7 Posts |
 Posted - 2007-12-03 : 11:17:27
|
| I have a DTS Package that runs every 4 hours to update files from an AS400 to an SQL Server. The first process Truncates all the Temporary Tables(42) on the SQL Server. The client called the other day and said the Package wasn't running any longer. It has been running for about 4 -5 months without issues. I manually run the process and it freezes up on 1 file and just says processing. I went into SQL and manually tried to truncate or delete but got the same results. I ended up deleting the table and re-adding which corrected the problem. Does anybody know a reason why data in a table would all of a sudden not be able to be truncated or deleted ?? They are running SQL 2000. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2007-12-03 : 12:42:56
|
| >>Does anybody know a reason why data in a table would all of a sudden not be able to be truncated or deleted ??the table could be "locked" by another process. next time that happens run "sp_who2 active" from a QA window. Look at the [blkby] column to see if that is the case.Be One with the OptimizerTG |
 |
|
|
scottjohniec
Starting Member
7 Posts |
Posted - 2007-12-03 : 14:03:19
|
| THANKS TG, I'll give that a try |
|
|
|
|
|
|
Trying to Truncate or Delete Temporary Files