sql server odbc:
hello,

1-I want a detailed step by step tutorial for installing SQL server 2000.
2- I want to install two SQL servers 2000 on the same machine, how could
i do that? (i mean will there be any change in the installation to the second
server?)
3- I want to know how to connect between these two servers.

thanx all for help

Hi Nada,

1-I want a detailed step by step tutorial for installing SQL server
2000.

-Put in the installion disk, install a second instance (named instance)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_install_259u.asp

2- I want to install two SQL servers 2000 on the same machine, how
could
i do that? (i mean will there be any change in the installation to the
second
server?)

-See point 1. Every instance is treated as a separate server aus every
service is independent to the other.

3- I want to know how to connect between these two servers.

You have to attach the servers as linked servers in order to see them.
Them you can access them with the four part notation:

e.g. Select * from Servername.DatabaseName.owner.Objectname

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_4uuq.asp

HTH, Jens Suessmeyer.