Cross-database instance Query

Code
Select * From OpenDataSource (
'Sqlodb ',
'Data source = 127.0.0.1; user id = sa; Password = Sa'
). Testdata. DBO. eh_jobsafeguard
Where 1 = 1

-- Enable ad hoc distributed queries:
-- Exec sp_configure 'show advanced options', 1
-- Go
-- Reconfigure
-- Go
-- Exec sp_configure 'ad hoc distributed queries ', 1
-- Go
-- Reconfigure
-- Go

-- Disable ad hoc distributed queries:
-- Exec sp_configure 'ad hoc distributed queries ', 0
-- Reconfigure
-- Exec sp_configure 'show advanced options', 0
--

Note: This method is feasible only when oledb connections are allowed.