Connecting Remote server with Local Server
Introduction: Linked server is powerful functionality provided by SQL Server. We can create object of remote server on local server and use that object to perform operations on remote server. To explain this topic let's consider a scenario Scenario: Local server having number of databases. We need to take backup of local databases and restored this database into the remote server. For this scenario we will follow certain steps: Step 1 : Create object of Remote Server Add remote server object in local server Syntax: sp_addlinkedserver @server = N'LinkServer' , @srvproduct = N' ' , @provider = N'SQLNCLI' , @datasrc = N'Server Name , @catalog = N'Database Name' Here we have created object of remote server i.e. LinkServer . By using this object you can perform Select, Update functionality on the same. Step 2 : Grant Permission Next Step...