A SQL Agent job failed with the following error: "Could not allocate space for object '<object>' in database 'tempdb' because the 'PRIMARY' filegroup is full." when running a stored procedure with select OPENQUERY to a remote database. We added 7 more files in the tempdb filegroup of database where the agent job is running and spread out the space among the files and has a total of 240G to play with. Also, we are only expecting about 700K of data from the query result. After rerunning the job, it failed with the same error. Is there something else that we are missing?
Is it possible that the tempdb it is complaining about is the tempdb of the remote server and not server running the job?