If the DBCC CHECKDB command doesn't work or to avoid data loss, you can use a professional SQL database repair software, such as Stellar Repair for MS SQL. It is an MVP-recommended software to repair ...

In SQL Server Management Studio (SSMS), you can see the SQL Server database state. Alternatively, you can use T-SQL commands to verify your database status. You can use the DATABASEPROPERTYEX function ...

I'm just wondering if the SQL Server will keep the attributes of the Access database, one of which is that zero length fields are not allowed.<BR><BR><B>-Erik</B> ...