Re: Updating a table in other MS Sql 7 DB

["David M. Thelen" <ddthelen@SBBSNET.NET>]

Doug,
Did you try qualifying the table name  i.e. 
servername.databasename.dbo.tablename?

Doug Nichols wrote:

>         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