Post reply

How to send query results to another server/database

  • February 8, 2010 at 4:09 am

    #220421

    Apologies if this is very simple, but I can't seem to find anything on the internet to help me with this.

    I have 2 SQL Servers, one of which I want to query and then output the results of this query to another database on the second SQL server.

    Can somebody give me a little help with this - I'm just trying to work out the structure of the code that I should be using, I'm sure I can work it out from there.

    Is it best to use the 2nd SQL server and then add the 1st (main) SQL server as a registered server?

    Really unsure where to start here... any help would be much appreceited.

    Thanks

  • February 8, 2010 at 4:15 am

    #1115376

    You can create the 'linked servers' and use the four part naming convention to access the data from linked server. Have a look in BOL about linked servers. It should be straightforward. Let us know if you are stuck!:-)

    ---------------------------------------------------------------------------------

  • February 8, 2010 at 4:17 am

    #1115377

    Thanks, I'll take a look now.

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

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