- .NET Component AlKhemeia.Geo – list of countries, cities and many more functionality
- .NET Simple Membership Provider for SqlServer, MySql, Access or Oracle
- System.Data.Entity.Validation.DbEntityValidationResult – Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details.
- Hyper-V – how to install legacy network driver for Windows Server 2003 virtual machine
- Determining how long a database will be IN RECOVERY (SQL Server 2008)
Category Archives: SQL Server
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
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
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
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
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
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