Using DBCC CHECKDB for SQL Database Repair REPAIR_ALLOW_DATA_LOSS argument with CHECKDB must be used only in an emergency and as the last option. It can fix errors that involve deallocating a row or ...

The Connection Properties dialog opens. For my sample ITworld application, I changed the data source to Microsoft SQL Server (SQLClient), and entered the necessary Server, Log On, and database values.