Home Forums SQL Server 2008 SQL Server 2008 - General It is possible to insert data from instance to other instance database. If yes then how to do. RE: It is possible to insert data from instance to other instance database. If yes then how to do.

  • 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"

    begin tran

    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 ?