OT: about MS SQL Server 7 and 2000

Hi, If your shop or your clients run SQL Server 7 or 2000, what additional features/functions (possibly substantial) that you think would be very helpful to your organization or your client and why? Thank you. Don

SQL Server 2000 made some improvements to the English Query, Full Text Indexing, OLAP, security, and web access functionality.  It has some IDE improvements - most notable is the Object Viewer. Personally, as far as I'm concerned the XML support that was added is what I consider most significant.  Before placing any weight on that, keep in mind that only a small number of people take advantage of this feature.  On the other hand, if you look at the list of features slated for SQL Server 2005 ("Longhorn"), many of themare XML-centric... Microsoft is obviously very interested in making working with XML easier and more appealling from a performance point of view (http://www.microsoft.com/sql/yukon/productinfo/default.asp).   This functionality really was introduced to SQL Server in version 2000. ~Simon Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org Chunshen (Don) Li wrote: ----- Excess quoted text cut - see Original Post for more -----

Well, probably I should re-phrase my posting as follows: What are the fundamentals (fundamental functions) that most small to medium sized organizations that use MS SQL Server 7 or 2000 most VALUE? OK, here's my biased definition of small to medium sized organization, annual revenue from 20m to 300m. Thanks. Don P.S. hope not too OT (could we stretch the language a bit?) ----- Excess quoted text cut - see Original Post for more -----