Post reply

How to do an insert to another server using TSQL?

  • May 18, 2005 at 2:26 pm

    #66117

    Hello Jedies of Sqlserver, someone know how to do a "insert" to another server using TSQL???

    for example insert into server1.base1.table1 values ('hello')

    thankss

  • May 18, 2005 at 2:31 pm

    #559717

    INSERT INTO server1.base.dbo.table1( Field1) SELECT Field1 FROM dbo.table2

    I wasn't born stupid - I had to study.

  • May 18, 2005 at 3:28 pm

    #559735

    has the other server been set up as a linked server?

  • May 18, 2005 at 4:36 pm

    #559743

    yes i coud do it, but mmmm i have read that the  distributed ransactions not will be affected into rollback but they are too,well by the tests that i have done ,ok thanks sorry my question , i must to resolve  myself ,but i have a stressed day, thanks a everyboy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply