Connection other database tables

We are finally moving off of Access to SQL Server 2000. In Access we can
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School District
Check SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:

>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>

Connection other database tables

We are finally moving off of Access to SQL Server 2000. In Access we can
attach all sorts of tables from different sources. In our SQL database, I
need to attach tables from other SQL databases as well as other odbc
sources. Then I will create views in order to utilize the data together.
How do I attach tables from another SQL database to the current?
Thank you
Gwen Powell
Torrance Unified School DistrictCheck SQL Server Books Online under the topic Linked
Servers.
-Sue
On Thu, 5 Aug 2004 13:38:39 -0700, "Gwen Powell"
<gpowell@.tusd.k12.ca.us> wrote:

>We are finally moving off of Access to SQL Server 2000. In Access we can
>attach all sorts of tables from different sources. In our SQL database, I
>need to attach tables from other SQL databases as well as other odbc
>sources. Then I will create views in order to utilize the data together.
>How do I attach tables from another SQL database to the current?
>Thank you
>Gwen Powell
>Torrance Unified School District
>

Connection from command prompt

All,
Though sound silly, but I require it by any chance...
I need to connect to the sql server 2000 from command prompt and then I
need to run query and see the resultset.
Any suggestion...'osql.exe in SQL 2000 (in SQL 2005 this command line utility is replace
by sqlcmd.exe). You can use the -q or -Q switches to specify a batch to
run rather than use it in interactive mode. Or even use the -i switch
to specify an input file that contains the SQL batch you wish to run.
*mike hodgson*
http://sqlnerd.blogspot.com
MUKUT wrote:

>All,
> Though sound silly, but I require it by any chance...
>I need to connect to the sql server 2000 from command prompt and then I
>need to run query and see the resultset.
>Any suggestion...'
>
>|||Mukut, Just do this,
1. Start >> Run >> cmd
2. osql /?
THis would list out the possible options for this osql utility.
I am sure this is what you are looking for :)
Best Regards
Vadivel
http://vadivel.blogspot.com
"MUKUT" wrote:

> All,
> Though sound silly, but I require it by any chance...
> I need to connect to the sql server 2000 from command prompt and then I
> need to run query and see the resultset.
> Any suggestion...'
>|||Thanks all for your kind suggestion.