And received those errors below
exec sp_msforeachtable 'delete from ? where employeeid in (select employeeid from tmpempid)';
While the first error is expected as not all tables have that column, the other errors are not..
Msg 207, Level 16, State 1, Line 1 Invalid column name 'employeeid'. DELETE failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. Conversion failed when converting the nvarchar value 'BARRY FADIMA' to data type int.
From novice to tech pro — start learning today.