I have a SQL Server linked to a non-SQL server using ODBC on our
internal network. Every query I run on the linked server from SQL
Server takes exactly 1 minute longer than to run the query via ASP
page and ODBC. I'm suspecting some strange handshake is going on when
the server is linked, and was wondering if there was a way around it?
I'd rather not tap into the remote server via ASP pages, but rather
have the ASP pages connect to the SQL Server.
Thanks
CateDo you run this query using 4 part naming or OPENQUERY?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment