Of the choices that you've presented, I would undoubtedly go with SQL Server 2005. And don't worry about the comment regarding beta testing it; the product has been out for several years now and is quite mature. :-)
I have used all of the following: Access MySQL 3.x, 4.x, 5.x SQL Server 7 SQL Server 2000 SQL Server 2005 PostgreSQL 8.x Access should not be used for anything other than learning basic SQL, in my opinion. That is what I used it for a bazillion years ago, and it did its job in that regard. Barely. MySQL: I hated 3.x, and I don't care for 4.x or 5.x. It's a personal preference thing. My #1 problem with 3.x is that sub-queries were not supported. Actually, I believe that 4.1 was the first version that supported them. Even now, sub-queries are not supported in the SELECT clause. SQL Server: Who cares about 7? 2000 is a great product, but, as someone else already stated, support for it will be disappearing soon. No way I'd go with that one these days. And 2005, I've been using it for 18 months or so now. Love it. Fast, efficient. IMO the best overall RDBMS for the average *web* application. HTH Matt On 10/18/07, Davide Campo <[EMAIL PROTECTED]> wrote: > > Hi to all, > i have to create a Database Server to work with ColdFusion. I'd like to > know what is (obvious by your personal opinion) the best Database Engine to > use (performance level, easiest sql language,compatibility, etc...). > That are my requirements: > - Op.System: Windows 2003 r2 Standard Edition > > - My possible DB Engines: > 1- SQL Server 2000 > 2- SQL Server 2005 > 3- My SQL > N- etc...(suggestions accepted, not oracle) > > > Tank you all > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291451 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
