Data From 2 SQL Databases

[MDW]

Hey all

I'm building an app in SQL Server 2000 - my first one (I was weaned on Access). I'm going to have some tables in my own SQL database, but I'm also going to need to get data from another SQL database on another server for lookups and whatnot. I'm trying to hash out a methodology to this. I can see one of two ways to do it -

1. Create two connections, one for each DB, and just use the one I need as I need t
2. Create some SQL server version of a linked table (this is possible, right?) and refer to everything in terms of my own DB

Assuming that #2 is possible, would either of those two methods be preferable, or is there another one that is even more so

Thanks.

[Aaron Bertrand [MVP]]

Create a linked server in SQL Server... then you can write stored procedures
that join local data to the other server... and your ASP app just has to
know there's "a data source" rather than know the specifics of multiple, or
even that there are multiple data sources...

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]




"MDW" <anonymous@discussions.microsoft.com> wrote in message
news:44397AB7-9C7D-47A2-B81C-779473B82D24@microsoft.com...

> Hey all,
>
> I'm building an app in SQL Server 2000 - my first one (I was weaned on

Access). I'm going to have some tables in my own SQL database, but I'm also
going to need to get data from another SQL database on another server for
lookups and whatnot. I'm trying to hash out a methodology to this. I can see
one of two ways to do it -

>
> 1. Create two connections, one for each DB, and just use the one I need as

I need to

> 2. Create some SQL server version of a linked table (this is possible,

right?) and refer to everything in terms of my own DB

>
> Assuming that #2 is possible, would either of those two methods be

preferable, or is there another one that is even more so?

>
> Thanks.