Tariq,

SQL Server can be slower than VFP, but it can also be faster. It really depends on what kind of hardware you use and what your queries are like. The latest version of SQL Server (7.0) is faster than previous versions.

If you have a very fast network and powerful workstations VFP will probably be fastest. If you have a slow network and a powerful server, SQL will probably be faster.

SQL Server is more complicated to work with, but once you learn it you'll find that you can still create applications quickly.

SQL Server has many other advantages over VFP (and other desktop databases like Access or Paradox) including:

Transaction Processing: A transaction is always fully committed or fully rolled back.

Reliability: Data corruption is much less likely than with VFP, Access, etc.

Replication: You can automatically sychronize data among multiple sites.

Table Size: VFP has a 2G table size limit. SQL Server has no limit as far as I know (if there is one, it's much larger than 2G).

Performance over slow networks: Over a dial-up or a WAN SQL Server will be much, much faster.

There may be others as well. You'll need to determine whether the advantages of SQL Server outweigh the additional expense of purchasing the product and maintaining it.

>Hi! All Fox Lovers!
>
>I am new in the visual environment of Foxpro and looking for secure database having password on its table. Some one asked me to use SQL Server at backEnd, Is it slow down the system or will give me any problem in handling database or pl! guide!
>
>
>Thanks