Troubleshooting

The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.

Question: What I’m I doing wrong and I’m getting the below error message when trying to list my database’s tables? Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that -most probably- (hey, you never know) you are using a SQL Server login that has conflicting permissions.…

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.…