Tag: SQL Query

How to Configure the Short Date Format in Windows and Windows NT

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 →

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 →