InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 07:31:11 GMT20http://www.sqlservercentral.com/Forums/Topic706110-5-1.aspxI don't know if you can buy SQL 2000 any longer. It's been out of support for about a year now. Is upgrading to SQL 2008 an option?Tue, 28 Apr 2009 14:20:51 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic706110-5-1.aspxThank you for the info !!! Thant's exactly what I needed...we have over 10 users and later on...more. We need to upgrade !Tue, 28 Apr 2009 14:04:53 GMTchilidogiehttp://www.sqlservercentral.com/Forums/Topic706110-5-1.aspxMSDE (Desktop engine) is a free restricted version of SQL 2000. It has a number of limitations built into it, one of which is a 5 connection limit. As soon as there are more connections that that, it will throttle performance down.Tue, 28 Apr 2009 12:09:02 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic706110-5-1.aspxWe run CAREWare freeware distributed by HRSA under the SQL 2000 Desktop Engine. NOT including additional bells and whistles, is there any computational (speed/ram, etc) advantage to using the desktop engine versus running under a data instance connected to the full-blown SQL-2000 Server ? I am looking at running the provided software only. Any extra query capability, file management, backup, etc, is not to be considered...performance only.Some here say we will have better response times using the full blown version, others say the desktop engine is better. I would assume that the actual processing of SQL is done by the same engine in both.Any ideas/comments ?Tue, 28 Apr 2009 11:33:23 GMTchilidogie