Hi,

I added ## to the table names to make tables temporary and it returned the following:

1. The message that it skips Foreign Key constraint that is not allowed on temp tables.

2. 4 rows affected. Which is expected message for the Insert statement

3. Msg 4701, Level 16, State 1, Line 1

Cannot find the object "emp_mgr" because it does not exist or you do not have permissions.

This is expected too because of the dbo prefix, discussed by other posters here.