Linked Server.

  • I have created a Linked server (SQL 7.0-SQL 7.0) and I am able to perform an insert and update. But after few such actions I get an error "OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory" I restart the SQL server 7.0 and the problem is solved for sometime. I can't afford to restart my SQL server everytime this happens

    is there any solution?

    The OS is Win2k advanced server

    RAM = 2GB

    Levi


    Jesus My Saviour

  • Running the current service pack?

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

  • The current service pack is 3..do you suggest SP 4. more over the problem is in our customer site and we have to be very correct that this will solve the problem...

    Levi.


    Jesus My Saviour

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

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