bryan 29523 (9/24/2013)
It's a production server, but there only 6 databases. I am considering detaching the DBs, wiping out the instance and re-attaching them.
NO.......
Dont try this ..there are very much chances that you wont able to attched them successfully.
TRy one thing .. have you try to query any user data base with sql prompt .
TRy to uninstall Sql prompt (if possible ) then do your querying.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)