[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Updating a table in other MS Sql 7 DB
- Subject: Updating a table in other MS Sql 7 DB
- From: Doug Nichols <drnichols@ATT.NET>
- Date: Tue, 2 Jan 2001 14:16:34 -0500
- Importance: Normal
Hi,
I am running an sqr against one database and want to select data from
and
update a table in another
database on a different sql server. I am runnin Sql server 7.0. I have
set
up a link between both database
servers and can select data fine. It's the update that fails. If I use
isql/w, the update query works fine, it just
doesn't work when I run it in my sqr program.
Does anybody have any tips?
thanks a lot,
Doug