our application has to integrate with another client application.so i need to send few tables data to another server .how can i achieve this..after browsing i cam to a conclusion that it will be achieved by Linked servers...what are the details do we need to know from client server?
If you have never set up a linked server before, using the graphical user interface might be easier and more intuitive. In SQL Server Management Studio's object explorer, right-click on the Linked Servers node under ServerName -> Server Ojbects and select New Linked Server. The dialog that comes up (there are 3 tabs) gives you a graphical way of specifying all the options you need to specify and test. The gory details are on this MSDN page: http://technet.microsoft.com/en-us/library/ff772782.aspx