B BobbyH Member Aug 2, 2005 #1 One of our developers is getting a "resource busy" error when trying to truncate a small table on a dev database. Nothing else going on at the time but a "delete from" works OK. Ideas? Thanks.
One of our developers is getting a "resource busy" error when trying to truncate a small table on a dev database. Nothing else going on at the time but a "delete from" works OK. Ideas? Thanks.
Marco Kalter Administrator Staff member Aug 2, 2005 #1 I think truncate is considered a DDL statement, and therefore the table needs to be locked. This restriction does not apply to the delete statement.
I think truncate is considered a DDL statement, and therefore the table needs to be locked. This restriction does not apply to the delete statement.
