Troubleshooting

Internal Query Processor Error: The query processor could not produce a query plan

OK folks, it did happen a few days ago to get this error message: Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services. I was trying to execute the following query: SELECT * FROM dbo.tbl1WHERE tbl2ID=(SELECT id FROM dbo.tbl2 WHERE Code=’Code1′)AND tbl3ID=(SELECT…

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

There are some times where database applications give the above error when trying to convert strings to the datetime format in SQL Server. This error is related to the default language and consequently the dateformat used by the corresponding SQL Server login. There are two approaches for avoiding/resolving this issue.…