We're developing a thick-cient VFP app that uses SQL Server 2000 tables.
The VFP app creates temporary tables (prefaced with '#') in SQL Server, for holding temporary lists of accounts/products that are eventually used as part of a SQL Stored Proc Query.
Someone told me that the ability to create temp tables (e.g. #LSTACCOUNTS, #LSTPRODUCTS, etc.) is only available in SQL Server Enterprise Edition, and that it might not be available in MSDE.
Is this true? What we're developing needs to work against the MSDE engine.
A related question is...what is the best source of information for capabilities in MSDE?
Thanks in advance,
Kevin