>Hi,
>
>I need to create a new application and was thinking about using SQL server as a database engine. Other than transactioning what benefits can I get by doing so? What are the main reasons to use SQL as my database engine? I plan to use the Microsoft 3 tier model.

If you are planning to use the Microsoft 3-tier model, then VFP as a back end is probably not a good idea. MTS, which I assume you are planning to use, does not support transactions to VFP.