>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.

Take a look at http://www.vitus.com/vfpcs.html

Also check the knowledge base, there is an article comparing VFP to the strengths and weaknesses of Access, VB and SQL Server.