Our environment has one SQL instance running a lot of our production databases. I also have a separate SQL instance on a whole other server infrastructure to support our SCCM environment that is running SQL Reporting Services. I'm using SQL Reporting Services on the SCCM SQL Server to run reports against databases on the other SQL instance. My question is, which tempdb will be used during the running of the queries in the reports I've created in SQL Reporting Services? Will it utilize the tempdb for the SQL instance on which the particular database resides, or will it use the Reporting Services tempdb on the SQL instance running Reporting Services?

Trying to clarify the scenario , Reporting Services does use a database called ReportServerTempDB which is used to store Reporting Services Data for big reports, Sanpshots and many other things. The SQL Server Instance has a differente temp database called Tempdb which is used for store temporary data used by the SQL Server Database engine, so lets say you have Reporting Services Catalog in ServerA and you are querying data from ServerB, in such case the SQL Server tempdb used would be the one in ServerB which is where the query is being executed and resolved. Jaime - http://blogs.msdn.com/b/jtarquino/ This posting is provided "AS IS" with no warranties, and confers no rights

Thanks for clarifying Jaime.