There was an unexpected failure during the setup wizard

In this article, we will be discussing how to resolve the following SQL Server error: “There was an unexpected failure during the setup wizard”.   When you might get this error OK folks, this is a little bit “tricky” issue. The scenario is the following: You are trying to install SQL Server 2005, then you … Read more…

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

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…

Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed…

In this article, we will be discussing about the following error message in SQL Server and how to easily resolve it: Creating an instance of the COM component with CLSID {AA40D1D6-CAEF-4A56-B9BB-D0D3DC976BA2} from the IClassFactory failed…   About this Error Message If you ever encounter issues when trying to create, add, or edit steps for a … Read more…

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

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

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…

Saving Maintenance Plan Failed (How to Resolve)

If you encounter the error message “Saving maintenance plan failed” when trying to save a maintenance plan you created using the the wizard in SQL Server 2005 Management Studio (SSMS), the first (obvious) thing you should try, is to check if the latest service pack is installed and if it is not then install it! … Read more…

Exclusive access could not be obtained because the database is in use

About the Error Message: “Exclusive access could not be obtained because the database is in use” A very neat feature of SQL Server is the way it lets the DBA to control connections. To this end, you can explicitly control connections with specific commands and methods. Even though this is not usually needed, there are … Read more…

A transport-level error has occurred when sending the request to the server

In this article, we will be discussing about the “A transport-level error has occurred when sending the request to the server” error message, you might get in SQL Server. This article’s purpose is to explain the above connectivity error and ways of resolving it.   Why you might get the “transport-level” error in SQL Server … Read more…

Divide by zero error encountered

In this article, we will be discussing about the “Divide by zero error encountered” error message in SQL Server. About the “Divide by zero error encountered” error message Well, as the error message says, whenever we have a division within a SQL query and the denominator has the value of zero (0) we get this … Read more…

String or binary data would be truncated

There are many times where a query may result to the following error: String or binary data would be truncated. The statement has been terminated. We will go through a simple example for explaining this behavior.   Reproducing the “String or binary data would be truncated” error Creating the Sample Table Consider the following table: CREATE TABLE … Read more…

The Multi Part Identifier Could not be Bound

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…

Microsoft SQL Server 2008 Feature Pack

This short post, discusses about SQL Server 2008 Feature Pack, what it is and what functionality it offers. SQL Server 2008 is undoubtedly an extremely powerful Relational Database Management System. It comes with many new features that increase the database developer’s productivity and make the life of the DBA easier. In September 2008, Microsoft has published … Read more…

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

About the char data type to a datetime data type conversion error There are some times where database applications give the following error when trying to convert strings to the datetime format in SQL Server: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.   How … Read more…