try exporting the package from SQL 2005 using Management studio, and import the package into SQL 2008 using Management studio(2K8)

yes, Tcp/Ip connections are enabled.

Firewall is not running. its disabled.

Hi everyone,

I tried above options, but the problem still exists.

When I run process cube from Management Studio, it finishes in about 20 minutes.

When the same thing is being executed from...

Thank you, every one for the responses.

I will try these options, and get back.

yes.

We have tried the following configuration setting also, but still it throws the same error.

-- SCRIPT START

sp_configure 'remote login timeout', 0

go

reconfigure with override

go

-- SCRIPT END

You may be able to decide this after reading this article.

http://toponewithties.blogspot.com/2004/08/difference-between-table-variable-and.html

Thank you.

Thank you all for the responses.

Here I have one more question.

Lets say, I have a table of size 2 TB(say Table000 ).

If, I have to run a simple query on...