Information générale
Forum:
Microsoft SQL Server
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement