MySQL does support transactions but only with certain table types namely InnoDb and BDB tables. ..however it doesn't support stored procedures or triggers.. yet Cheers Rich -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Joel Canfield Sent: 16 July 2002 14:59 To: 'thelist at lists.evolt.org' Subject: RE: [thelist] SQL Server 2000 or mySQL? -- [ Picked text/plain from multipart/alternative ] > Is SQL Server 2000 really worth the money, or is mySQL > running on Win2K a reasonable alternative (especially given > it's price)? MySQL doesn't support transactions, I think. Unless your app depends on transactions, you should be fine. I use MSSQL 2000 at work, 'cause my purchasing app really requires a transactional database. But I'm playing with MySQL, and for the little stuff I do much more often, I prefer it. Especially at that price ;) joel -- For unsubscribe and other options, including the Tip Harvester and archive of thelist go to: http://lists.evolt.org Workers of the Web, evolt !