Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Connecting to a server

Author  Topic 

sudha12345
Starting Member

47 Posts

Posted - 2009-04-23 : 06:43:48
Is there any approach that through a procedure we can connect to the databases in different servers and select the data

Sudhakar

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2009-04-23 : 06:45:57
Yes, it's called the Front End approach.

[Signature]For fast help, follow this link:
http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspx
Learn SQL or How to sell Used Cars
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page
   

- Advertisement -