Post reply

Connect String to another server

  • February 28, 2006 at 8:27 am

    #111984

    I need to run a stored procedure to dump data from one server to another.

    How can I get the SQL Query Anallyzer to see this other server?

  • February 28, 2006 at 8:39 am

    #623712

    Hi,

     

    Create a linked server and execute the query using the  (linked server name).

    ex: select * form [192.168.1.14].databasename.dbo.tablename

    u can also use select * into tablename from [192.168.1.14].databasename.dbo.tablename

    from

    Killer

  • February 28, 2006 at 9:43 am

    #623736

    Created the linked server.

    Why do you recomend to use the raw IP address?

  • March 1, 2006 at 2:03 am

    #623875

    Hi,

    I had not recommended to use the ip address , i had given u an example

    u have to use the name of linked server.it may be ipaddress or anyother name

     

    from

    Killer

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

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