Yes, that's exactly what I ended up doing.
Even though the ODBC DSN connected to the DB successfully, TP still couldn't create thumbnails. This lead me to realize the script that created the DB wasn't catered to my install; specifically this message: ThumbsPlus Message <5015-8036>.
While the <5015> code provided me with no "real" insight and only indicated "The "error_message" text will contain more detailed information about the specific database error"; I opted to look more into the <8036> code which simply states to see error <8001>.
<8001> = "Error adding volume (serial=, label=; which pretty much spelled it out for me, ThumbsPlus couldn't create thumbnails as it didn't know the hard disk drives volume label.
Therefore, I reopened the Thumbs9_mssql.sql script in SQL Analyzer and using Edit | Find and Replace | Find in Files, I changed "Look in" to Current Document making sure my cursor was in the Thumbs9_mssql.sql, I "Volume" as the "Find what" criteria and clicked "Find All". The results returned the following:
\Documents\SQL Server Management Studio\Projects\SQLQuery1.sql(114):CREATE TABLE [Volume]
\Documents\SQL Server Management Studio\Projects\SQLQuery1.sql(132): FOREIGN KEY REFERENCES [Volume]([idVol]) ON DELETE CASCADE ,
\Documents\SQL Server Management Studio\Projects\SQLQuery1.sql(277):insert into "ThumbsPlusDatabase" values ('volume_match', '3'); -- Network name | No CD serial numbers
I then placed my cursor at the front of the first item found and clicked the SLQ button "Go to the location on the current line" which took me to:
CREATE TABLE [Volume] in the script, leaving the brackets in tact I placed the volume label of my hard disk drive in between the brackets.
Next, I clicked on the SQL button "Go to the next location in the list" which took me to CREATE TABLE [Path] - and more specifically to FOREIGN KEY REFERENCES [Volume]([idVol]) ON DELETE CASCADE , - here I was somewhat confused so I left it alone.
Again, I clicked on the SQL button "Go to the next location in the list" which took me to: insert into "ThumbsPlusDatabase" values ('volume_match', '3'); -- Network name | No CD serial numbers. As in the previous step I was a bit confused so I left it alone.
Parsed the script successfully and then Executed the script which of course returned some invalid entries as some of the script entries were already present. Saved the script as a different name (just in case); closed MS-SQL Server Management Studio and renamed my existing C:\ProgramData\ThumbsPlus\Thumbs.tpdb8 to Thumbs.tpdb8.bak so ThumbsPlus9 would prompt for the New Database Creation or Connect to ODBC Data Source. Selecting Connect to ODBC Data Source and selecting the same DSN previously created allowed for a successful connection. Attempted to create a single thumbnail and it was successful, therefore, I went to the top of my hierarchy and selected the top folder and selected "Make thumbnails in tree". It is now at 19.5% and seems to be creating thumbnails properly at this point.
Re-opening the newly saved script and searching for my hard disk drives volume label, the two entries in which I left alone are now populated with my HDD volume label, so apparently SQL Server 2005 took it upon itself to propagate the HDD volume label to the necessary locations in the script.
Hopefully, this information may be of assistance to others who choose to utilize MS-SQL Server 2005 with TP9 in the future.