Even though SQL Server 2000 is no longer officially supported by Microsoft, quite a few SQL 2K databases still exist in production environments. One that had been giving me trouble for a couple of days was intermittently causing a web app to fail, and the error message indicated that the failure due to either a … Read more
A couple of weeks ago, I attended Houston’s first Open Innovation Hackathon and joined the team that had the goal of redeveloping the City of Houston City-Wide Fee Schedule. The current fee schedule is an ASP.NET Web application with a SQL Server back end. At the end of the hackathon, my team had put together … Read more
I am in the process of writing scripts to move data from a SQL 2000 database into a different database running on SQL 2008. I had set up a linked server from the SQL 2k server to begin this process, and about 90% of the data could be moved. One of the last tables to … Read more