How to connect two differect instances of SQL SERVER

How to connect two differect instances of SQL SERVER on LEN or WAN for Data Migration.MSDN (http://msdn.microsoft.com/sql)
and read about linked servers, DTS, replication...|||Each instance of SQL Server 2000 listens on a unique set of network addresses so that applications can connect to different instances. SQL Server 2000 clients do not need any specific configuration to connect to an instance of SQL Server 2000.


The SQL Server 2000 client components query a computer running one or more instances of SQL Server to determine the Net-Libraries and network addresses for each instance. The client components then choose a supported Net-Library and address for the connection automatically, without requiring any configuration work on the client.

The only information the application must supply is the computer name and instance name.
http://www.winnetmag.com/Article/ArticleID/37794/37794.html for further information.sql

how to completly remove all sql instances!

Hi there,

I kinda play with MSDE / SQL Express and now I need to remove everything!

I did the manual remove (http://support.microsoft.com/kb/320873/EN-US/)
but I did copy the osql.exe file.

Now, when I do osql -L to list the instances, I got 4 of them!
all of which I have no idea how they got there.. and the names tell me nothing (nothing I ever typed during my test!)

- JUKELANSRV\SQLEXPRESS
- QUAD-1800
- SERVEURSQL (that's in French!)
- VIVENDI

the only thing that MIGHT have cause SOME of these (certainly not all), is ENSIM X PRO

Anyway.. I need to remove them all and everything related to SQL.

Thanks for any response!Any thoughts on this?|||Himartinbl, as I understand the osql -L command is used to list all servers detected on the network, including SQL aliases created on local client. If you want to check installed SQL instances on you local machine, you can check in registry or services.msc

how to combine two different SQL server data instance into one db?

Hi

I'd like to know how I can combine two tables from two different sql instances ito one db?

thanks.

Volkan, can you provide a little more info?

Are you trying move the data from sql instance 1 and sql instance 2 into a new database on sql instance 3?

Are you asking how you can query the data from two different instances?

You can query separate instances by using a four-part qualifier if the instances are defined as linked servers.

select * from [servername].[databasename].[schema].[tablename]

Example: server = MySQL1, database = MyDatabase, schema = dbo, table = MyTable

select * from MySQL1.MyDatabase.dbo.MyTable

|||

If both the DBs are on same Server and the current user have access permission on both database then you can use the following query..

Select SomeColumns From CurrentDBName..TableName
Select SomeColumns From OtherDBName..TableName

If the databases are on different Server then you have to use the Linked Server..

EXEC sp_addlinkedserver @.server = 'SERVER', @.provider = 'SQLOLEDB.1', @.srvproduct = '', @.provstr = 'Privider=SQLOLEDB.1;Data Source=TargetServer;Initial Catalog=Database'

go
Exec sp_addlinkedsrvlogin @.rmtsrvname = 'SERVER', @.useself = true, @.locallogin = null, @.rmtuser = 'Userid', @.rmtpassword = 'Password'

On your SP you can use..

Select * From OpenQuery(MyRemoteServer, 'Select * From Sysobjects')

--OR

Select * From MyRemoteServer.DatabaseName.dbo.Sysobjects