When I access data through the direct method i.e.
select * from LINKED_SERVER.DATABASE.USER.TABLE
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error. The provider ran out of memory.
When I access the data using the OPENQUERY i.e.
select * from OPENQUERY( LINKED_SERVER, 'select * from DATABASE.USER.TABLE' ) it works.
Any hints as to why it will not work one way but it does the other?
St. Joseph's Hospital
Marshfield, WI 54449
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!