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 |
|
KimJ
Starting Member
38 Posts |
 Posted - 2005-01-28 : 14:58:17
|
| Hi - I'm truncating a table, and it's been going for quite some time. Unfortunately I don't know how many rows are in the table - how abnormal is this amount of time? Can/should I stop it?Thanks in advance,Kim |
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2005-01-28 : 15:05:45
|
| It may be possible that some other process is holding a lock on the table that you are truncating. check with sp_who2 for any blocker/blockee issuesThanks--Harvinder |
 |
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-01-28 : 15:13:44
|
| You are absolutely correct - is it safe to kill the truncate job? |
|
|
|
rubs_65
Posting Yak Master
144 Posts |
Posted - 2005-01-28 : 15:15:05
|
| yes you should be able to kill it without worry. |
|
|
|
KimJ
Starting Member
38 Posts |
Posted - 2005-01-28 : 15:16:49
|
| Thank you - I appreciate the help! |
|
|
|
|
|
|
Truncate table running for 40 minutes!