Error Messages

Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

Installing SQL Server 2016 on Windows Server 2012 R2: Rule KB2919355 failed

If you are trying to install SQL Server 2016 on Windows Server 2012 R2, under certain circumstances, you might get the below error message: Rule “KB2919355 Installation” failed. KB2919355 Check Failed. If you have installed KB2919355, please make sure you have restarted your machine. For more information, you can visit…

The transaction log for database ‘dbname’ is full due to ‘XTP_CHECKPOINT’‏

When using In-Memory OLTP in SQL Server 2014, under certain conditions you might get the below error message: The transaction log for database ‘[database_name]’ is full due to ‘XTP_CHECKPOINT’‏  This was fixed in Cumulative Update 3 for SQL Server 2014 SP1 More information about the fix can be found here.

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

There is insufficient system memory in resource pool ‘internal’ to run this query.

There is insufficient system memory in resource pool ‘internal’ to run this query.

This article discusses the following error message: There is insufficient system memory in resource pool ‘internal’ to run this query. Even though you might get the above error message for different occasions, one thing is for sure (after all, the message is quite self-explanatory), it has to do with memory…

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…