Hello everyone

Just a quick question as a visual foxpro developer if I was thinking about moving over to SQL Server, rather than having machines processing queries. What sort of problems could I expect ? All I here is SQL Server will solve all my problems, speed, network traffic etc But Ive been in this game to long and know nothing is this simple. So what can the downfalls be? Also is there any point moving to sql server, what size data do I need to justify it etc

Any info would be advantageous, I would rather listen to the people here than other so called experts who are trying to plug a product!

ps currently we use NT/Novell Servers with anything from 5 to 400 workstations.