"Chedva" <chedvag@matrix-it.co.il> wrote in message
news:eoueGxomGHA.1912@TK2MSFTNGP02.phx.gbl...
>A SP with join's between tables of 2 SQL 2000 linked server used to work
> relatively quick.
> Since a few weeks the same SP that runs on +/- the same amount of data
> takes
> much more time (43 sec).
> When i copied the DB so that the SP should run on the same server it takes
> only 13 seconds.
>
> Probably the customer installed on the server but obviously they deny that
> :)
>
>