Thanks for the reply. what i m doing it is only for test purpose.
I having two instances - "Rajesh\SQLINST1 " and Rajesh
1. My database is in "Rajesh" instance - Database (name is test), (schema is dbo), (table is block)
2. I have created linked server in "Rajesh\SQLINST1 " which is other instance
3. I was trying to access data from ""Rajesh\SQLINST1" - (for test database which is in other instance)
(select * from Rajesh.test.dbo.block) this data base is in other instance "Rajesh" - Completed successfully
Now I want to insert data from "Rajesh\SQLINST1 " to "Rajesh"
insert into Rajesh.test.dbo.block values (30)
error - Msg 8501, Level 16, State 3, Line 2
MSDTC on server 'RAJESH\SQLINST1' is unavailable.
but in other case ( if i will removed "begin tran) and using only
(insert into Rajesh.test.dbo.block values (30)) - it is working fine.
my question - using link server it is possible or not to insert uncommited data ?