How do I connect from one SQL Server database to another?
How do I connect from one SQL Server database to another? Follow these steps to create a Linked Server:Server Objects -> Linked Servers -> New Linked Server.Provide Remote Server Name.Select Remote Server Type (SQL Server or Other).Select Security -> Be made using this security context and provide login and password of remote server.Click OK and you are done !! What is a SQL connection? A SqlConnection object represents a unique session to a SQL Server data source. With a client/server database system, it is equivalent to a network connection to the server. SqlConnection is used together with SqlDataAdapter and SqlCommand...