Welp, we use enterprise versions. The cost of another SQL Server Enterpise would be about $ 11,000.00 USD.
Sometimes we have to balance the costs of upgrades to new servers versus the rewards and conversion costs. Admitidly there are many reasons to go to SQL Server 2003, however for us it would also entail moving to Win 2003 Advanced Server so another 5K plus CALs. Oh, yes, I really would like to deploy a replacement to our SQL 7.0 ( we are using SQL 2000 but not for web work ).
For many companies it many not be worth the price. However short note in the ASP script to disregard the error and a "why" might be of assistance to others ? Would you not agree ?
BTW I, for one, think this is a good thing we are discussing here, provided no one takes offense, because it sounds like a few of us have been around this block many times and maybe we might add something of benefit to our less experienced collegues. After all it is what Forums are for, no ? And I learn some things along the way also. After 30 years in the compuiting business, right back to the days where we were a cabal of mysterious programmers working in assembly, there are many things yet for me to learn. Thus discussions here and everywhere, allow myself to learn many new things and new ways of thinking, working on systems, and wokring throughout the world. I am hoping all will agree ?
Jon Spartan.