Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1029
  • Last Modified:

SQL Server Error message

I am trying to run a stored procedure which may create temporary tables. When I try to run it it gives the following error message:
Executed as user: NT AUTHORITY\SYSTEM. Invalid object name '9b9e4463b6344b849407fc65a21b5d47PolicyResults1'. [SQLSTATE 42S02] (Error 208).  NOTE: The step was retried the requested number of times (1) without succeeding.  The step failed.
Please help!
0
hraja77
Asked:
hraja77
1 Solution
 
Ashish PatelCommented:
Please check the db owner access on the database where you are creating temporary table ie. may be tempdb and provide access create, alter etc rights.
0
 
imran_fastCommented:
That account needs the permission. Give this NT AUTHORITY\SYSTEM read write permission on your user database.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now