Daily Archives: April 8, 2009

Here's a trusted connection example.

SELECT *
FROM 	OPENDATASOURCE(
'SQLOLEDB',
'Data Source=SQLDEV;Integrated Security=SSPI'
).[pubs].dbo.[authors]