Thaks all for prompt help

Actually, we have linked our SQL Server with ERP system in Oracle. We sync the orders data from oracle to SQL Server for Manipulation. so we...

No I dont want to access that i was just asking from conceptual point of view so that when i have to write UDF then i should be very clear...

Hi,

Please ignore the reply if its irrelevant.

Use the command below on the command prompt

isqlw -S [server] -d database -U [sa] -P [sa] -i c:\a.sql -o c:\a.txt

OR

osql -S qaserver -d...

Deal All,

We had the same problem that the linked Access DB gives error that 'table not found', we figured out that if we open the linked Access DB and try...

Thanx,

But this will load to and from DB, i just need to ask that will i be using ADO steram object in my application to load and store image from...