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.
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
Him,
I am using mssql 2012 enterprize edition with serice pack 1.
Any solution.
hi there,
we have ssms 2008 on our one of server.
the same error message as per the screenshot is coming in ssms.
Can this be fix by installing the ssms 2008 r2.
Please advise.
Many thanks
Pooja