Problem solve Get help with specific problems with your technologies, process and projects.

Why is the stored procedure looking for the temp table?

I have a stored procedure that uses a temporary table, ##tmp, to store manipulated data and moves this manipulated...

data into a permanent table. Then a select query within the stored procedure displays the results from the permanent table.

When i call this stored procedure within DTS in order to export the output, DTS comes up with an error stating that it can't find the ##tmp table. Why is it looking for the ##tmp table?

Because it is trying to resolve everything you have placed in the package. The global temp table will have to exist before the procedure is called, or

For More Information

it is going to fail.

This was last published in February 2003

Dig Deeper on SQL Server Stored Procedures

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.