Post reply

SQL Query Analyzer - SQL Statement on different servers

  • March 7, 2005 at 12:54 pm

    #67077

    I need to create an SQL statement that copies records from SQL Server to another.

    Example:

    Update    <foreign server.dbo.table>

    Set        <field> = NULL

    Where     <local server.dbo.table>.<field> IS NULL

     

    Foreign Server is an Internet address that I have access to.

    Local Server is my PC

    (A simple solution is to export my records, and Import them on the other server as a different table, but I was looking for a different solution.)

  • March 7, 2005 at 1:06 pm

    #545773

    Have a look at "Linked Servers" on BOL

    BTW the statement should use 4 part names like:

    <ServerName.DBName.dbo.table>

     


    * Noel

  • March 7, 2005 at 1:10 pm

    #545776

    > Have a look at "Linked Servers" on BOL

    What is BOL ?

    > BTW the statement should use 4 part names like:

    > <ServerName.DBName.dbo.table>

    DOH!  I knew that!  It just slipped my mind.  Not enough coffee yet today. 

    Thanks!

  • March 7, 2005 at 1:17 pm

    #545777

    Sorry,

    BOL = Books OnLine

     


    * Noel

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

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