MSSQL - fix error Cannot drop the table '#test', because it does not exist or you do not have permission.

watch solution on YouTube


Cannot drop the table '#test', because it does not exist or you do not have permission.


to fix it replace

Drop Table #test

with

IF OBJECT_ID('Customers..#temp') IS NOT NULL
Drop Table #test