SQL SERVER: MS SQL 2005
Precondition: Linked Server already configured (There are plenty of resources online)
Reason for post: Difficult to find solutions, mostly found how to configure with a couple with how to access but didn't work for me; used following queries:
"Linked Server query"
"access Linked Server"
"MS SQL linked server query"
My Issue: I needed to access a scalar data on a table from another SQL server with Linked Server already configured
My Solution:
SELECT field FROM [Linked Server Name].[Database Name].[User (typically dbo)].[Table Name]
Post-Mortem: The solution is so obvious after I got it to work, but I'm sure I'll forget anyways in about 10 years.
No comments:
Post a Comment