Category Archives: SQL Server

Determining how long a database will be IN RECOVERY (SQL Server 2008)

I have come across a situation where SQL Server crashed in the middle a process of shrinking log files of a database of size 10+ GB. After restarting SQL Server I saw the database in question has gone IN RECOVERY … Continue reading

Posted in SQL Server | Tagged , | Leave a comment

Microsoft Dynamics CRM 2011 Server installation – “The instance name must be the same as computer name”

Recently I have come across an issue¬†“The instance name must be the same as computer name” while Microsoft Dynamics CRM 2011 performs a system check during installation. During diagnostic check CRM performs a query against the server bound to the … Continue reading

Posted in Microsoft Dynamics CRM, SQL Server | 1 Comment

Dynamics CRM – Issue with publishing reports for external use – System.Web.Services.Protocols.SoapException: One or more data source credentials required to run the report have not been specified.

We have quite a few reports in Microsoft dynamics CRM 4.0 which are normally run from within CRM 4.0 without any issue. Some of the reports are added to SQL Reporting Server utilising dynamics CRM but are accessed externally from … Continue reading

Posted in .NET C#, Microsoft Dynamics CRM, SQL Server | Tagged , , , | Leave a comment

Bulk load: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.

While using BULK INSERT statement in SQL Server 2008 to import tab delimited file in a table you might come across the following error: Bulk load: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because … Continue reading

Posted in SQL Server | 2 Comments

Exclusive access could not be obtained because the database is in use

You may come across an error as shown below while backup/restoring a database using SQL Server Management Studio 2005. Restore failed for ‘servername’ (Microsoft.SqlServer.Smo) Additional information: System.Data.SqlClient.SqlError: Exclusive access could not be obtained because the database is in use. (Microsoft.SqlServer.Smo) … Continue reading

Posted in SQL Server | 1 Comment

cannot be reused until after the next BACKUP LOG operation.

When trying to create a full text index on a database you may get the following error message: “File ‘index’ cannot be reused until after the next BACKUP LOG operation” Solution (SQL Server 2005): 1) Right click the database and … Continue reading

Posted in SQL Server | Leave a comment