Truncate table taking lot of time

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Truncate table taking lot of time

Author

Topic

chetan_zzz
Starting Member

2 Posts

Posted - 2006-08-09 : 02:56:21

Hi,
I am running this truncate table command on a table which is taking lot of time comapred to delete statement. Infact it running forever. I tried to to run it on empty table still it is taking lot of time.

Please advise.

-Chetan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources