Solved

SQL Server Error message

Posted on 2007-11-20
2
862 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how the fundamental information of how to create a table.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now