I am trying to update an ntext field between two servers.
The sintax I am using is the following:
DECLARE @ploc binary(16)
DECLARE @prem binary(16)
SELECT @ploc = TEXTPTR(ntext_field)
FROM tablename
where id = 55298
SELECT @prem = TEXTPTR(ntext_field)
FROM SVR.DBNAME.dbo.tablename
where id = 55298
print @ploc
print @prem
UPDATETEXT tablename.ntext_field @ploc 0 NULL
[SVRNAME.DBNAME.dbo.tablename.ntext_field] @prem
I am testing a simple query to understand how it works
before doing an update on multiple records.
The pointer contains the correct values (if I run the
query on two local table it works fine), but if I run it
with a remote server the result is the local filed empty
without uptateing it.
The error is:
The number name 'SRVNAME.DBNAME.dbo.tablename' contains
more than the maximum number of prefixes. The maximum is 3
on the UPDATETEXT line.
Thanks for your help.
Dario
Hilary Cotter - 14 Jul 2004 17:27 GMT
I think you will find that ADO's stream object is much easier to work with
for things like this.

Signature
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
> I am trying to update an ntext field between two servers.
> The sintax I am using is the following:
[quoted text clipped - 30 lines]
>
> Dario