Database name databasename ignored, referencing object in tempdb

This type of warning you got while working with stored procedure.

Warning : Database name <databasename> ignored, referencing object in tempdb.


Causes: while working with the temporary table you might be used the temp table reference with schema.

ex: select * from databasename.dbo.#tmpTable

this syntax gives you a warning message

Solution:
Don't use reference in your query.

ex: select * from #tmpTable

Sql server will auto manage the temp table with the different different database temp table in tempdb.

Delete encryption key from report server

If unable to delete encryption key from SQL server reporting service configuration manager, to delete it manually use below stored procedure.

use ReportServer

exec DeleteEncryptedContent


If you find any difficulty, feel free revert.

Above stored procedure is predefined in Report Server.