Solved

SQL Server Error message

Posted on 2007-11-20
2
922 Views
Last Modified: 2011-10-03
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
Comment
Question by:hraja77
2 Comments
 
LVL 23

Accepted Solution

by:
Ashish Patel earned 500 total points
ID: 20318902
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
 
LVL 28

Expert Comment

by:imran_fast
ID: 20318938
That account needs the permission. Give this NT AUTHORITY\SYSTEM read write permission on your user database.
0

Featured Post

Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question