I'm new to Distributed Transaction, and i'm getting this error
Server: Msg 7377, Level 16, State 1, Line 5
Cannot specify an index or locking hint for a remote data source.
I need to have the locking hint within my query, but i have to connect onto another server so I have to use the distributed transaction for me to be able to create a transactional query.
This is my situation:
my PC is in 192.168.1.101 and the server in on 192.168.1.100
I am testing this query:
DECLARE @ID AS BIGINT
SELECT TOP 1
@ID = [ID]
ROWLOCKED = 0 AND
ISPROCESSED = 0
now im stuck : (
Please I need your expertise on this.
ToM™ (Possibility will come out of nothing)