Error Messages

A network-related or instance-specific error occurred while establishing a connection to SQL Server

by

In this article, we will be discussing about a popular error message, that is: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”   About the network-related or instance-specific error Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error … Read more…

Error converting data type varchar to float

by

Sometimes, under certain circumstances, when you develop in SQL Server and especially when you try to convert a string data type value to a float data type value, you might get the error message: error converting data type varchar to float. As the error message describes, there is a conversion error and this is most … Read more…

Resolving the Error Message: Rule “KB2919355 Installation” failed

by

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.  Read the article below, in order to get useful suggestions on how you can overcome such issue.   The Error Message The below, is the exact error message you … Read more…

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

by

Question: What I’m I doing wrong and I’m getting the following error message when trying to list my database’s tables? “The SELECT permission was denied on the object ‘extended_properties’, database ‘mssqlsystemresource’, schema ‘sys’.” Here’s the screenshot also: Answer: Are you ready for the simplest explanation ever? 🙂 The reason is that -most probably- (hey, you never … Read more…

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

by

This article discusses how you can resolve the 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 management. 🙂 … Read more…

Argument data type ntext is invalid for argument 1 of left function

by

When you try to run a string function directly on a text or ntext column, in this example the “LEFT” function, you will get the following error: Argument data type ntext is invalid for argument 1 of left function. Similarly, if you try to run the REPLACE function against a text or ntext column, you will … Read more…

Could not load file or assembly ‘Microsoft.SqlServer.Smo, Version=10.0.0.0, …

by

I have recently experienced an issue which had to do with a third-party application that was trying to retrieve some meta information from a specific SQL Server Instance. It was actually trying to retrieve the names of all the databases contained within that instance. However it was returning the following error message (app code excluded): […….] … Read more…

Database [Database_Name] cannot be upgraded because it is read-only or has read-only files

by

This article, discusses how you can resolve the error “Database [Database_Name] cannot be upgraded because it is read-only or has read-only files“.   About the Error Message At some point in the past, I was trying to attach some databases on a SQL Server 2005 instance. The database files were copied over the network and … Read more…

No global profile is configured. Specify a profile name in the @profile_name parameter

by

At some time in the past, I set up a maintenance plan in one SQL Server instance for rapidly tuning up a set of databases with some simple tasks such as index rebuild, etc., and I got the error message: “No global profile is configured. Specify a profile name in the @profile_name parameter”.   About … Read more…

The Multi Part Identifier Could not be Bound

by

There are cases where a SQL Server database developer might get an error message similar to: “The multi part identifier could not be bound“. This happens because of the way the database developer handles table scopes within the query. Read the article below, in order to better understand this error, and see how easy is … Read more…