Hi,
I've to retrieve information from MS SQL Server linked server table(from Pervasive SQL). I found this query "select * from LINKSERVER3.DBCLN3.Schema.table3" what's Schema in the query? How do you find it? Thanks for your time,

Jay.

Well found the solution myself. I read in another forum that I can leave the Schema part blank and it worked.
LINKSERVER.DBCLN..cdtbl1

However my data retrieval is very slow bcoz of some other reasons. My pervasive sql database is on Netware server and my MS SQL Server 2000 is on a windows 2000 server. I'm connecting pervasive sql through linked server in MS SQL Server. when I try to open any table it's very slow. Any ideas?

Jay.