>>If I were to entertain this, how about this for starters: A single table - say 10 gb in size, full text search - accessed over a wan.
>
>Ok, there's one requirement from you. So far we require the solution must accomplish:
>
>1. Full text search on a single table 10 table over a WAN
>
>I think its doable. You might have the cleaner solution, but your suggestion that our flexibility tests end after one requirement is entertaining!
>

It is not doable - at least not for you. Considering that a Fox table can only be 2gb in size - I would say you are 8 gb shy...


>I'll add one:
>
>
2. We must be able to deploy multiple versions of the platform for multiple versions of the application
>

What does this mean?

>
And since that makes us even, I'll throw out another one, and then you can respond with whatever else you would like to see flexibility include:
>
>3. We must be able to create tables on the fly with minimal rights to the Operating System
>

Considering SQL Server has its own security, I could easily deal with that by simply loging on as sa or by creating a user with admin rights - with no effect on the OS.

My reply to this is that the solution would have to allow simultaneous access to a table by multiple users while re-indexing.


So far, there are at least 2 things Fox is not capable of doing.

Let me know when you have had enough...

< JVP >