I had been doing a lot of banging around in the sandbox when I started getting a
COM error in my application. After much debugging I decided to try and redeploy
the solution to a fresh web application, but I was still getting the cryptic COM
error. I went digging and I noticed that each time I provision a new web
application, a row is getting created in the dbo.Solutions table in each new
content database with my sandbox solution in it, even though I have never
deployed anything to the site. I just verified that the solution is in the
database before I even create a root site collection for the web app.
I have created three web applications with the same behaviour, and the sandbox
solution row in the database exists in WSS_Content and all other
WSS_Content_<guid> databases. Any thoughts as to why this might be happening,
or what I can do to fix? I have been googling and looking into some sort of
Content Database "reset", as this is a development environment and I don't mind
blowing everything away, but I would like to be more knowledgeable about a good
way to handle something like this. My worst case scenario would be to reinstall
MOSS. Is there anything else I could consider?