We have an offsite hosted SQL Server which houses our Student base. I want to create custom relational tables in my local Express instance to be joined to the remote student table. Within SQL Server Management Studio I have active connections to my local instance as well as the remote server. What is the query join syntax for linking a local table to a remote table?
local table tblTestScores with hypethetical fields StudentId TestName TestGrade
remote table tblStudents with hypethetical fields StudentId FirstName LastName
I want to create a join between these two tables but I don't know the syntax for referencing the remote table. Any assistance would be appreciated. Thanks
Thanks Jim, When you say linked server to your remote connection do you mean simply using the Connect to Server window when starting Managment Studio or is there a more official connection that I need to make as the Connect to Server connection doesn't persist across restarts of Managment Studio? Thanks again.