Friday, March 9, 2012

server with SQL 2005

In SQL 2005 I have created a linked server with a DBF table.
I used the Stored Procedure SP_addlinkedserver.
With MS SQL Server Management Studio I used the "New Query" function and write: "select * from LKserver...LKserver " and used the "execute" command to view my DBF table on Results Window. It is fast!!
if I create a view with the same linked server and execute it with "Open View" I receive a "timeout exception error"
Why ?
thanksPerhaps you need to create the view on the linked server, not on the local server.|||?! It is not possible to create a view on a linked server, expecially if it is a DBF table!
If I use the View I have a problem of "time expired" then I must maximize the query time but I don't know where to do it?!

No comments:

Post a Comment