You may get the following error messages in SQL Server:

Server: Msg 3624, Level 20, State 1, Line 1
Location: recbase.cpp:1378
Expression: m_offBeginVar < m_SizeRec
SPID: 51
Process ID: 948
Connection Broken

Or

[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken 

These error messages are particularly encountered when the user attempts to add a column to the existing table through INSERT command. If the applied transaction also retains the foreign key reference to the column, which has been declared as the unique clustered or non-clustered index key on the table, then this could be the reason of problem.

Actually in this condition, the clustered index gets corrupted. When the add column attempt gets failed, the clustered index can get corrupted and the data may become inaccessible.

The clustered indexes are those where the columns to be searched lie adjacent to each other. These indexes determine the physical order in which the data lies in the table and are useful in increasing the accessing capability of the data.

When the clustered index gets corrupted there in no report generated by running the DBCC CHECKDB, but the access performance of the database gets degraded and hence you need an immediate SQL recovery through the trustworthy tool.

The best solution, to have SQL repair completely, is to make use of the third party applications which are well suited for this job. Actually they avail a safe MDF recovery and so are recommended for the best part.

With the intuitive user interface, these MDF repair utilities benefit you the easy procedure. They work for all the objects of SQL Server database and are the flaw-free SQL recovery solutions, if and only if the correct one has been chosen.

Stellar Phoenix SQL Database Recovery software does the most effective SQL repair in all the cases of corruption. This MDF recovery tool runs the most effective algorithms to retrieve the information up to max. Valuable for recovering all the objects, this is well packaged with the graphically rich user interface.

This MDF repair application is read-only and works for SQL Server 2000. This is the most exquisite solutions for all the problems.