I am not sure if this issue was fixed or you found a way around your issue. But I am writing the fix I found to hopefully help someone else. While I have not asked any questions, I am going to explain a scenario to give you an idea of how to fix it. scenario: You may have migrated your db to a newer server and you are trying to run a stored procedure from Database A that tries to create a table in the tempdb. If that is correct, the issue you are having is trustworthiness and you need to grant several permissions:

1. Enable Trustworthiness on database A
2. Grant execute on the stored procedure to the user account you are using
3. If you are running it from task scheduler / cmd using bcp or sqlcmd, give the account the following permissions to the tempdb ONLY, datareader, datawriter, ddladmin.

These three things will solve your issue.