Linked Server error

I have 2 servers SQL7 and SQL2000.
When I run a query from 7 to 2000 (via link Server) I get the following
error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of
memory.
ANy help on this will be greatly appreciated.
Thanks,
Drop thje Link Server and recreate. Is this on win 2000 ad server? If so do
you have sp4 installed? If not then install it. Also post your test query.
"XXX" wrote:

> I have 2 servers SQL7 and SQL2000.
> When I run a query from 7 to 2000 (via link Server) I get the following
> error:
>
> Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of
> memory.
>
> ANy help on this will be greatly appreciated.
>
> Thanks,
>
>