Here's a trusted connection example.
SELECT * FROM OPENDATASOURCE( 'SQLOLEDB', 'Data Source=SQLDEV;Integrated Security=SSPI' ).[pubs].dbo.[authors]
Related posts
Add comment
History
SQL SERVER DATABASE ADMINISTRATOR, DEVELOPER, began working with computers in 1980. Specializing in MS SQL Server 2000, 2005, Transact SQL, Stored Procedures, DTS.