Not enough storage is available to complete this operation

Question

Not enough storage is available to complete this operation

Alex A

SSC Enthusiast

Points: 179
More actions
April 26, 2006 at 2:08 pm

#365995

We have vendor application that executes DTS package with Lookups option. When this package runs from the application it works. If I execute it from the Database Server side it returns the following error:
Not enough storage is available to complete this operation.
What makes this DTS package to run to Success from application and fail when I run it from Database Server Side?
I will appreciate your help.
Alex

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Yelena Varshal SSC-Dedicated Points: 34287 More actions · Answer 1

Alex,

You may want to check the size of your TempDB and if any growth restrictions are applicable and how much disk space is available.

Also if DTS package explicitly specifies a drive letter that is available on the clients (like drive C)but not available on the server it could be a problem. I did have a couple of similar cases with Drive Letter-specific setups

Regards,Yelena Varsha

Brad Aitken Grasshopper Points: 19 More actions · Answer 2

Hey Alex,

check this url: ( the artcile suggests a hot fix from microsoft ?? )

http://support.microsoft.com/?kbid=889170

Cheers

Brad

ClauBra Valued Member Points: 68 More actions · Answer 3

Hi,

I have applied the SP4 SQL2000 and solved this problem!

The problem was the lookup on win3k and sql2000 SP3.

Claudete

Kindest Regards,

Clau

chrisp-757679 Newbie Points: 9 More actions · Answer 4

Hi Yelena. I am having the same problem as the thread starter, and have found that my tempdb is indeed smaller than the DB I am trying to perform a copy database operation on. If I increase the size of the tempdb, do I risk damaging anything else?

Thank you,

Chris.