Access Data From Multiple SqlSever Instances

Hi
I am having two SQL Server instances installed at two different systems and want to fetch data from both of them in a sigle query with joins. Somebody suggested that I need to link up the sql server instances at the admin level. If you have an idea about the process of linkng multiple sql server instances kindly convey it to me.

For Details of the discussion kindly follow the undergiven link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=138563&SiteID=1

Thanks

How to add linked servers is described in the Books Online topic for sp_addlinkedserver and the related topics. See ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/fed3adb0-4c15-4a1a-8acd-1b184aff558f.htm.

|||Thank you Steven, I'll check it up.

acces multiple servers

Hi,

I need to access a table from another server in my procedure...I am now connected to say SERVERA...I need to access another table SERVERB.TABLE2 in the same procedure...

Is there a way to do that...

I need to connect to two servers from the same procedure to get data..

Please get back

Thanks,

Hi Swapna,

Yes, there are a few methods, however the most straightforward would be to create a linked server.

Have a look at BOL or http://www.databasejournal.com/features/mssql/article.php/3085211 for more info.

Cheers,

Rob

|||Thanks a lot Rob...It was very helpful

accepting multiple values in data-driven subscription

I have set up a data-driven subscription based off an SQL table. It works in
all cases except when I am trying to select all or multiple values for a
parameter. Does anyone know how this needs to be set up in the SQL table so
that the report will accept multiple values?
ThanksHi Marie,
I encountered the same problem. Did you get any solution yet from other
forums?
Thanks,
Rares
"Marie M." wrote:
> I have set up a data-driven subscription based off an SQL table. It works in
> all cases except when I am trying to select all or multiple values for a
> parameter. Does anyone know how this needs to be set up in the SQL table so
> that the report will accept multiple values?
> Thanks

Accept Multiple Values

Hi ,
Is it possible to declare a variable to accept mutiple values at a time ?
for example :
Declare @.Country char(100)
Set @.country = 'TH','MY'
"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:DF03833A-4A65-4969-A661-D98DCB859489@.microsoft.com...
> Hi ,
> Is it possible to declare a variable to accept mutiple values at a time
> ?
> for example :
> Declare @.Country char(100)
> Set @.country = 'TH','MY'
>
No arrays in SQL Server. What are you trying to do? Maybe this will help:
http://www.sommarskog.se/arrays-in-sql.html
David Portas
SQL Server MVP
|||Do not think there are arrays you can use fixed length , delimited or
XML
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

Accept Multiple Values

Hi ,
Is it possible to declare a variable to accept mutiple values at a time ?
for example :
Declare @.Country char(100)
Set @.country = 'TH','MY'"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:DF03833A-4A65-4969-A661-D98DCB859489@.microsoft.com...
> Hi ,
> Is it possible to declare a variable to accept mutiple values at a time
> ?
> for example :
> Declare @.Country char(100)
> Set @.country = 'TH','MY'
>
No arrays in SQL Server. What are you trying to do? Maybe this will help:
http://www.sommarskog.se/arrays-in-sql.html
--
David Portas
SQL Server MVP
--|||Do not think there are arrays you can use fixed length , delimited or
XML
--
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

Accept Multiple Values

Hi ,
Is it possible to declare a variable to accept mutiple values at a time ?
for example :
Declare @.Country char(100)
Set @.country = 'TH','MY'"Travis" <Travis@.discussions.microsoft.com> wrote in message
news:DF03833A-4A65-4969-A661-D98DCB859489@.microsoft.com...
> Hi ,
> Is it possible to declare a variable to accept mutiple values at a time
> ?
> for example :
> Declare @.Country char(100)
> Set @.country = 'TH','MY'
>
No arrays in SQL Server. What are you trying to do? Maybe this will help:
http://www.sommarskog.se/arrays-in-sql.html
David Portas
SQL Server MVP
--|||Do not think there are arrays you can use fixed length , delimited or
XML
--
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

about multiple clients

I have a sql server application program developped with ODBC. The program can
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll past end or before beginning of data".
Could you tell me the reason ?
it seems the program got failure when trying to find next row, but the
position may not point to an valid row,since the row could be deleted by
other process from another machine.

about multiple clients

I have a sql server application program developped with ODBC. The program ca
n
run at different computer and realize synchronization operation. But
sometimes it has error message :
"Attemp to scroll past end or before beginning of data".
Could you tell me the reason ?it seems the program got failure when trying to find next row, but the
position may not point to an valid row,since the row could be deleted by
other process from another machine.