Basically, SQL 2000 was installed to run an application, but now the vendor has suggested we upgrade to 2008.
The only thing "plugged in" to SQL is the application.
There are no ad hoc queries or anything so I hope it's a straight forward deal.
A third or fourth breed would result in (I assume) ?
name isDoberman isRottweiler isBoxer isPitBull ?
I think you need to also incorporate a PIVOT in there, else you will have a case every time you have a new breed, unless you dynamically build the case statement based on distinct breeds of dogs (which can be cumbersome).
I didn't mean to imply that both would be running in tandem, 2008 was placed over 2000.
I patched 2000 up to SP4, ran the Upgrade Advisor which deemed all agreeable.
However, after the upgrade one of the databases was offline.
It appeared healthy in Management Studio, but it had no system properties, no tables, nothing.
Fortunately I had a backup from 5 minutes before the upgrade.
I restored the DB with that backup, 2008 took the restore, and it's been smooth sailing since then.
I hope this information helps anyone with a similar project.