>how to connect MS SQL Server in VFP 6 with service pack 5.
>& what's the step for that.
As Sergey said, there are different ways to do it, and the book he suggested is a good overview.
The simplest way to read a SQL Server table is to create a ODBC DSN, either in Control Panel or Administrative Tools, depending on what OS you're using. Then, you can use the SQLCONNECT() function to connect to the server, and SQLEXEC() to send the SELECT commands.
lnH = SQLCONNECT("MySQLServer")
SQLEXEC(lnH, "USE northwind")
SQLEXEC(lnH, "SELECT * FROM customers")
BROWSE
Then there's Remote Views, ADO, etc... hard to answer your question without knowing what the final destination is.