Professional Web Applications Themes

How to get the data from Two servers - Microsoft SQL / MS SQL Server

Dear Freinds I have server A with database ABC and Server X with database XYZ I want to take the data from both ther server how i can do the same please suggest. Thanks for your guidence in advance. Best regards NiitMalad...

  1. #1

    Default How to get the data from Two servers

    Dear Freinds

    I have server A with database ABC and Server X with
    database XYZ

    I want to take the data from both ther server how i can
    do the same please suggest.

    Thanks for your guidence in advance.
    Best regards
    NiitMalad

    Niitmalad Guest

  2. #2

    Default Re: How to get the data from Two servers

    You can use the concept of linked servers to achieve this. Essentially, you
    will create a named reference to the other server from one server. Post that
    you can access the server and its data by using a 4 part naming convention
    like: Server.Database.User.Object. Check out the setting-up of linked
    servers in SQL Server BOL.
    --
    HTH,
    SriSamp
    Please reply to the whole group only!
    http://www32.brinkster.com/srisamp

    "Niitmalad" <co.in> wrote in message
    news:095801c366ef$3cb5f340$gbl... 


    SriSamp Guest

  3. #3

    Default Re: Return value from store procedure

    Marcin,


    Check Sql server "Books On Line" for sample code.
    "Using Return Code and Output Parameters for Stored Procedures"

    hth,
    Praveen
    MCSD, MCDBA

    "Marcin" <onet.pl> wrote in message
    news:#phx.gbl... 
    puserID 


    praveen Guest

Similar Threads

  1. Parallel Data keeping on remote servers
    By bigbrain28 in forum Coldfusion - Advanced Techniques
    Replies: 5
    Last Post: November 9th, 12:49 AM
  2. Passing Data Between Servers
    By Paul in forum PERL Beginners
    Replies: 6
    Last Post: March 5th, 09:27 AM
  3. Replies: 0
    Last Post: November 14th, 10:39 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139