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…