Accessing data through a linked server

[azeke]

I'm running SQL Server 7.0 When running a stored procedure that access data or calls another stored proc in a linked server, I sometimes get a timeout error. If I rerun the proc again, it works. Any ideas what the problem or solution is???

 

[TomSark]

Linked servers can be very slow, especially if you are going through the OLEDB for ODBC driver that is going through another ODBC driver to get to the data.

I would try use a specific OLEDB provider for the 'other' server and avoid going though too many layers. Tom Davis
tdavis@sark.com

http://www.sarkdallas.com