SQL Tutorials

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

                                           

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

Description:

After connect the sql server from local system it is giving  Index was outside the bounds of the array. (Microsoft.SqlServer.Smo).It is not expanding the tables error message is continuously coming.

Index was outside the bounds of the array

Solution:

In general this issue is raised incorrect of SQL SSMS version.In other case recent update of SQL version from SQL 2008 version to SQL server 2012 it will raise these errors.

For SQL Server 2012 edition download the below mentioned.It contain the complete pack of SQL 2012 express edition along with Management Studio.

www.microsoft.com/en-us/download/details.aspx?id=29062

For SQl Server 2008 or SQl server 2008 R2 version of service update the service pack that can be resolve the issue.

SQL Server 2008 Service Pack 1
SQL Server 2008 R2 Service Pack 1

Latest Service packs resolve the connecting errors.

Tags:SQL,SQL server,SQL server 2008,SQL server 2008 R2,SQL Server 2008 Sp1,SQL Server Sp2,SQL errors

About the author

admin

2 Comments

Click here to post a comment