Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    233

    Unanswered: sqlExpress select from other server

    I have sqlexpress db local on my computer and would like to do a select from another server that i have a connection to.

    The other server is Al and database is Acct and table is Jan09.

    Thansk!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Search for "linked server" in books online

    Oh, and the The fact you have a table called "Jan09" is a whole different discussion...
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •