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
Please download the Sql Server 2008 R2 Service Pack3 from the given URL
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.