Resolved : How to remove SQL Error Window “Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

In this blog, we’ll discuss how to fix “Index was outside the bounds of the array” SQL error.

While trying to open / view the functions / stored procedures / views or any other SQL object of higher version of SQL Server like SQL Server 2012 or above from SQL Server 2008/ 2008 R2, we are getting a SQL Error Window, which says the below and not allow us the open the SQL objects, though the user might have the full rights in that particular database of the SQL Server.

“Index was outside the bounds of the array.(Microsoft.SqlServer.Smo)”

It is actually an exception generate while connecting to higher version of SQL Server like 2012 & above from SQL Server 2008  or SQL Server 2008 R2.

To resolved this exception, Microsoft release an patch in 2014 which, which will eliminate this exception and the user can easily connect with higher version SQL Server from SQL Server 2008 or SQL Server 2008 R2.

Please download the Sql Server 2008 Service Pack4 from the given URL

https://www.microsoft.com/en-in/download/details.aspx?id=44278

Please download the Sql Server 2008 R2 Service Pack3 from the given URL

https://www.microsoft.com/en-us/download/details.aspx?id=44271

In the download link after click on the submit button, you need to select the 32 or 64 bit as per your system.

 

Please share your valuable comments.

Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s