Home Database name 'tempdb' ignored, referencing object in tempdb
Reply: 0

Database name 'tempdb' ignored, referencing object in tempdb

user564
1#
user564 Published in August 15, 2018, 8:44 pm

Instead of checking temporary table existence like this:

IF OBJECT_ID('tempdb..#table') IS NOT NULL
BEGIN;
    DROP TABLE #table;
END;

I am using the new DROP IF EXISTS technique:

DROP TABLE IF EXISTS tempdb..#table;

It is working perfectly, but if the table do not exists, I am getting the following message.

Database name 'tempdb' ignored, referencing object in tempdb.

Does anyone know why and what this message mean?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.298524 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO