Locking Hint Problem On Multi-servers

Hi All,

I want to lock 2 tables on 2 servers using TABLOCKX
hint. These tables function as semaphores in my
application. It means when the tables are locked
then other users will not be able to access them
and automatically they can not continue their works.

I have tried using the following code, but it
does not work. I always got the error :
"Cannot specify an index or locking hint for
a remote data source" on the select command.

begin tran
select * from server1.accounting.dbo.semtab
with (tablockx) where fprefix = '000'

select * from server2.accounting.dbo.semtab
with (tablockx) where fprefix = '000'
-
-
commit tran

The error will disappear if I remove the server
name, like this :

select * from accounting.dbo.semtab
with (tablockx) where fprefix = '000'

But, it does not meet my requirement.
It only locks one table on one server(default).

Please help me

Thanks in advance

John S.




*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!