Thanks for your reply.


If I understand this, the application will have to issue an sp_addlinkedserver.

But I'd like to define a persistant server object. I'll give you a bit more info so you understand what I'm trying to do.


I have a DBL database that runs on a UNIX server (RDL2). I have a SQL Server 2000 (RDL1).

RDL1 has to be able to issue DML statements against the DBL database. I have installed the ODBC Drivers on RDL1 for that provider. Right now, I can access the data through a system DSN.

I will need to define a job (running in Sql Server) that will retrieve new data from 2 tables that resides on DBL (RDL2). It will transfer data from those tables into SQL Server tables, delete the remote rows, and sleep for a while.

How whould you "attack" this ?

Thanks