Error deleting all tables “DELETE failed because the following SET options have incorrect settings: ‘QUOTED_IDENTIFIER'”

Add the SET options to the delete call.

These still apply to the other items mentioned in the error, even though you disabled FKs.

This will work around any saved or environment settings

Edit, after comment

EXEC sp_MSForEachTable 'SET QUOTED_IDENTIFIER ON; DELETE FROM ?'

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)