How to query a linked server

[Guest]

I have an existing Linked Server on SQL Server 2005 where the Provider is
"OLE DB Provider for Microsoft Directory Services".

I need to query this provider from a C# application and store the results in
a dataset.

The closest information I could find is

http://msdn2.microsoft.com/zh-tw/library/ms162171.aspx

but this actually creates a Linked Server instead of "using" an existing one.

Thanks.

 

[Cowboy \(Gregory A. Beamer\)]

A sproc that calls the linked server is the easiest to me, but as long as
you alias the server properly, you can do it with sql in your objects. In
this instance, the procedure will add a bit of security.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************