SQL Server Linked Database

Tuesday, 22 November 2005

I was using one database (DB1) and wished to refer to a table in another database on the same server (DB2).
This is accomplished without resorting to sp_addlinkedserver.

USE DB1
GO
SELECT TOP 20 * FROM DB2..TABLE1

Observe that there are two periods between DB2 and TABLE1. This is not a typo.

The entry 'SQL Server Linked Database' was posted on November 22nd, 2005 at 8:57 pm and last modified on November 25th, 2005 at 12:01 am, and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.