Index was outside the bounds of array

Question

Post reply

Index was outside the bounds of array

VirusDetected

SSC-Addicted

Points: 426
More actions
November 12, 2013 at 2:45 am

#279981

Hi

I am experiencing of problem relating to the error message on the production SQLServer2012;

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

Your advice in the matter is very important.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Abu Dina SSChampion Points: 14155 More actions · Answer 1

I think I've had this error when connecting to a SQL 2012 instance using the wrong version of SSMS. Are you using the 2012 SSMS version to connect?

---------------------------------------------------------

It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn

VirusDetected SSC-Addicted Points: 426 More actions · Answer 2

VirusDetected

SSC-Addicted

Points: 426

November 12, 2013 at 3:19 am

#1665667

I am using 2008 and I see that SSMS 2008 has limited options. Is there any way to bypass because I installed backward compatibility tool.

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 3

Please , could you tell us the exact version ( last SP + CU installed ) on your both SQL Server 2012 ( 1st post ) and 2008 ( used SSMS in your last post ) ?

It is always possible to use a SSMS 2012 to open a SQL Server 2008 or SQL Server 2008 R2 ( if you are looking to the facets of an object like database ,view , table , you could get the value "not supported in this version" or a similar message ).

If you try to connect to a SQL Server 2012 thru a SSMS 2008/2008 R2 , Microsoft does not give any warranty that the connection will succeed. I have got even an error caused by an unknown value in an enumeration ( this value appeared in 2012 and was not existing in 2008 ) .

Example :

the value Version110 ( corresponding to SQL Server 2012 ) is not supported in a SQL Server 2008 SSMS ( not defined in the SMO namespace ).

Same problem with Visual Studio which is unable to load the project created with a newer version.

I think that you should replace your SSMS 2008 by the SSMS Express 2012 SP1 which is the full version supporting Entreprise Edition

http://msdn.microsoft.com/en-us/evalcenter/hh230763.aspx

http://msdn.microsoft.com/library/ms143506(v=SQL.110).aspx

http://msdn.microsoft.com/en-us/library/jj200106(v=sql.15).aspx