If the database has been repaired you can simply put the database back into an online state using the ALTER DATABASE command. <pre>ALTER DATABASE DatabaseName SET ONLINE</pre> If the database is still corrupt you can not do this, as the database will still report as corrupt and mark it self as suspect. You have to restore the database to another name, then move the missing data (that you can access) from the corrupt database to the restored database. Onve you have the data, you can drop the corrupt database, rename the restored database and get the system working again. Don't forget to backup the database when you are all done.

If the database has been repaired you can simply put the database back into an online state using the ALTER DATABASE command. <pre>ALTER DATABASE DatabaseName SET ONLINE</pre> If the database is still corrupt you can not do this, as the database will still report as corrupt and mark it self as suspect. You have to restore the database to another name, then move the missing data (that you can access) from the corrupt database to the restored database. Onve you have the data, you can drop the corrupt database, rename the restored database and get the system working again. Don't forget to backup the database when you are all done.