Thanks for the idea. The connection strings are defined in the SSIS package properties so it shouldn't depend on the which account runs it (though it does use the credentials...

Sergiy,

I tried that test to call an alternate procedure and can confirm we are screwed. Thanks for the heads up.

I've passed the info back to the application support team....

Hi Lilia,

I'm not sure what you are trying to achieve with this effort.

If the table in question has no clustered index, then the data pages will not be contiguous....

Thanks for your feedback Sergiy.

Yes the dev application only takes a few seconds for us also, but in Production with a reasonable amount of data in the system tables the...

Thanks Elizabeth.

Dang!

In that case, is there another way I can remedy the performance problems of this stored procedure? We have a 3rd party web application that is timing out...