Seven hours!

Ladies and gentlemen, some advice:

When you are developing a software system in environment A with the full intention of rolling it out in environment A, do not be so foolhardy as to allow the Powers That Be to decide it will be rolled out in environment B. What should have taken an hour or so, took me seven hours today. The software that I wrote was developed to work with multiple databases on a single database server. Instead it was decided at the last minute to split the databases over multiple servers, each of which is a different version; and by the way, so is the operating system. In Windows 2003, Microsoft added some additional security measures to DTS and nested transactions that use DTS which gave me the majority of my headaches today.

That fact that I screwed up a password lost me only about one half hour.