SQL Server Performance Forum – Threads Archive
Insufficient Memory, Linked ServerI’ve to populate table on SQL Db with information stored in dbase III file.
I create Linked Server using ODBC to dbase III file.
After I execute sp which has OPENQUERY(Linked_Server,SQL Statement),
This SQL Database have performed Insufficient Memory. I can’t connect with Enterprise Manager with error can’t not find server, my rest application can’t access this server. why .?? This Server has 2GB RAM (Dedicated Server), I alocate 512M to OS (WIndows 2K Advance Server). the Rest is for SQL2K Memory.
Thanx in advance
WHat was the exact error you’re getting when trying to access thru linked server?
Check thru sql server error log for more information. _________