This post explains the error message you might get in SQL Server: The OLE DB provider “SQLNCLI11” for linked server “[…]” supplied inconsistent metadata for a column. The column “[…]” (compile-time ordinal 1) of object “[query…]” was reported to have a Incomplete schema-error logic. You might get the above error message, when you are trying … Read more…
Under certain circumstances, when working in SQL Server Management Studio, you might get the error message “Property SpaceAvailabable is not available for Database ‘[tempdb]’“. Why I got this message? Most of the times, you might get the above message because something else happened prior to the action that triggered the error message. For example, … Read more…
This short tip is about how to handle the following error message, in case you get it when you install SQL Server 2019 RTM: An error occurred for a dependency of the feature causing the setup process for the feature to fail. How to Resolve the Issue There several things you can try for resolving … Read more…
This is a quick tip, on how to resolve the error message “The description for Event ID 1 from source msodbcsql13 cannot be found.” when trying to start SQL Server Agent. After you ensure that everything is OK with the service account running the SQL Server Agent service, and that the SQL Server service is … Read more…
Sometimes, under certain circumstances, when trying to edit an existing or create a new maintenance plan in SQL Server, using SSMS, just when you try to save the maintenance plan, it might happen to get the error message “No Description Found“. How to Resolve the “No Description Found” Error There is a series of … Read more…
So, you have a clustered SQL Server instance (FCI), you try to move (fail over) the entire role to another node of the cluster and you get the below error message: Error Code: 0x80071398 The operation failed because either the specified cluster node is not the owner of the group, or the node is not … Read more…
This post helps you how to resolve the BULK INSERT-related error in SQL Server: Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row… , column … Reproducing the issue with an example Consider an example where you have a text file which you want to import in … Read more…
In some cases where you might try to launch SQL Server Configuration Manager, you might get the error message: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager. Invalid namespace [0x8004100e] … Read more…
While developing data processes in SQL Server, under certain circumstances, you might get the error message: error converting varchar to numeric. This error is similar with the conversion error you might get when you are trying to convert a varchar to float, etc. Read on to find out the reason for getting this error message and … Read more…
This short blog post helps you troubleshoot the below error message in SQL Server Reporting Services (SSRS): An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError) Get Online Help For more information about this error navigate to the report … Read more…
Among its plethora of available and useful settings, SQL Server has a setting that is called “Maximum number of concurrent connections“. This setting by default is set to 0 (zero), which means “unlimited” concurrent connections and it is generally advised not to change it. In case you changed this setting there is the risk to … Read more…
Under certain circumstances, there are cases where you might try to connect to a SQL Server instance and get the error message: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server … Read more…
If you are trying to start SQL Server Agent and you get the error message SQLServerAgent could not be started (reason: Unable to connect to server ‘(local)’; SQLServerAgent cannot start) then read below, in order to see what you can try for resolving the issue. How to Resolve the Issue Go to computer management … Read more…
When writing T-SQL code, at some point, under certain circumstances, you might get the error message: ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Explaining the Error Message with an Example But let’s take things from the beginning with the use of an example. First, let’s create a temporary … Read more…
So, you ran a query and got the error message: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. As the above error message explains, you are trying to run a SELECT INTO statement without specifying a column name. Consider the below example: SELECT 1, ‘TEST1’ … Read more…
