Repairing a Microsoft SQL Server Database
The database repair process analyzes an At Your Service Microsoft SQL Server database for data integrity in order to resolve potential data problems.
Before repairing the database, you must ensure that all
other users are out of the database. This includes temporarily closing the At
Your Service – Internet Utility (see Exiting the Internet Utility). To
analyze and repair the open database file, first close all windows within the
main program shell and then select File 
Repair Database from the main menu.
Only the program administrator (see User
Security) may repair the database. A prompt will verify the request before
proceeding.
(See also Repairing and Compacting an Access Database, and Repairing a MySQL Database.)
Microsoft SQL Server Database
Administration