/* Used this after McAfee decided my hard drive was "removable" and set it to read-only as per the company group policy */
/* Making it read-only made all the databases unavailable but once it was writeable again the code below fixed them */

ALTER DATABASE [my_database_name] SET SINGLE_USER WITH NO_WAIT
ALTER DATABASE [my_database_name] SET EMERGENCY
DBCC checkdb  ([my_database_name], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [my_database_name] SET ONLINE
ALTER DATABASE [my_database_name] SET MULTI_USER WITH NO_WAIT