[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



        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