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.

  • Syntaxwise, it simple:

    INSERT mytable (...)

    SELECT ...

    FROM SERVER.db.dbo.tbl

    What do you mean with "not able to insert"? You are just staring into the blue and can't figure out the syntax? Or did you trying something like above, but got an error message? Could you be more detailed?

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]