If you backed up your databases before doing this, you could just restore over the bloated ones and be done with it. If not, you may have to use ShrinkDB... <shudder>

Be very careful with this, but you can shrink the database file. Be aware that it basically trashes your indexing, so you would have to rebuild your indexes afterward. Here's a good article on SHRINKDB. http://blog.sqlauthority.com/2010/08/12/sql-server-shrinkdatabase-for-every-database-in-the-sql-server/

I would probably find and download Ola Hallengren's reindexing code. Tons of people use it and it works a champ.

Personally, I would wait until someone really smart answers... but in order to reclaim your drive space, you're going to have to use ShrinkDB. Just don't go thinking that you should use it all the time. Read this if you think that's a good idea:

http://www.brentozar.com/archive/2009/08/stop-shrinking-your-database-files-seriously-now/