[First Post Ever] **Easiest Way** (SSMS) You can't script it through openquery if you don't have permissions on the master database (nor should you). From the object explorer +Linked Objects ++Linked Servers +++[Linked Server Name] Left click the linked server name Script Linked Server As > Create To > New Query Editor Window Look for @datasrc='linked server source here' Voila! I know this was asked 4 years ago, but can I get some ^^ love?