We develop web based software so most of time we have to face date time format problem. In our all of the project we prefer to use short date time format in US format (MM/dd/yyyy). But most of clients now a days while installing OS set the Indian English format so we have to face … Continue reading How to Configure the Short Date Format in Windows and Windows NT
Category: SQL Tips
Database Error : Unable to find index entry in index
Recently we faced the following error in our live database of one of our esteem clientDatabase Error : Unable to find index entry in index ID 1, of table 1360723900, in database 'Database Name'. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. … Continue reading Database Error : Unable to find index entry in index
Error in Crystal Report with Visual Studio 2013 in windows Applications
Error : Could not load file or assembly 'file:///C:\Program Files\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one of its dependencies. The system cannot find the file specified. Solutions : Goto Your App.Config file and add following code in between <configuration> </configuration> tags <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/> </startup> Please also … Continue reading Error in Crystal Report with Visual Studio 2013 in windows Applications
SQL SERVER – Auto Complete and Format T-SQL Code – Devart SQL Complete
SQL SERVER - Auto Complete and Format T-SQL Code - Devart SQL Complete. By Pinal Dev Some people call it laziness, some will call it efficiency, some think it is the right thing to do. At any rate, tools are meant to make a job easier, and I like to use various tools. If we … Continue reading SQL SERVER – Auto Complete and Format T-SQL Code – Devart SQL Complete
SQL SERVER – Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL
SQL SERVER - Fix Visual Studio Error : Connections to SQL Server files (.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL.
SQL SERVER – Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3
SQL SERVER - Sends backups to a Network Folder, FTP Server, Dropbox, Google Drive or Amazon S3.
Sukh Vir Singh's Blog 