Professional Web Applications Themes

Accessing an alternate SQL Server within a proc - Microsoft SQL / MS SQL Server

Is it possible to access a database on one SQL server from a stored proc on another SQL server? I'm sure there must be a way, but I've never needed to do it before and I can't seem to find a reference to it in books online. Thanks!...

  1. #1

    Default Accessing an alternate SQL Server within a proc

    Is it possible to access a database on one SQL server from
    a stored proc on another SQL server? I'm sure there must
    be a way, but I've never needed to do it before and I
    can't seem to find a reference to it in books online.

    Thanks!
    rebam Guest

  2. #2

    Default Re: Accessing an alternate SQL Server within a proc

    Yes you can set up the server as a linked server & use 4-part naming or
    passthrough queries like OPENQUERY to access other SQL Servers. See details
    about linked serve and associated methods in SQL Server Books Online.

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Sen Guest

Similar Threads

  1. CF Server Choking When Calling STORED PROC
    By mostof in forum Coldfusion Database Access
    Replies: 2
    Last Post: May 15th, 08:32 PM
  2. accessing SO at server side
    By avanthika in forum Macromedia Flash Flashcom
    Replies: 5
    Last Post: April 13th, 09:25 PM
  3. Accessing LDAP server with ASP
    By mel finney in forum ASP
    Replies: 1
    Last Post: July 31st, 11:15 PM
  4. SQL Server - Alternate for First() Last() functions available in MS Access
    By Arun Subramanian in forum Microsoft SQL / MS SQL Server
    Replies: 6
    Last Post: July 10th, 07:11 PM
  5. Accessing data on a SQL-server
    By Søren Jensen in forum ASP.NET General
    Replies: 1
    Last Post: July 5th, 01:42 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