Index exceeds the array bounds

Sql2008 connect to the database server display index exceeds the array bounds, what reason, how to solve the problem, solution

Started by Meredith at November 13, 2016 - 5:53 PM

Reference resources

Posted by Enoch at November 17, 2016 - 6:26 PM

You is it right? Even 2012 examples?

Posted by Heidi at December 02, 2016 - 6:35 PM

2012 SSMS and 2008 are not the same, some functions will have this kind of situation, either using the 2012 SSMS, or patch

Posted by Heidi at December 07, 2016 - 6:44 PM

I called sql2008sp1, but still wrong, still need to hit what patch.

Posted by Meredith at December 13, 2016 - 7:17 PM

Not SP1, some fix patch, I forgot to find where

Posted by Heidi at December 17, 2016 - 7:44 PM

In fact, T-SQL operation is no problem, but you have to use the mouse to open the table, open the stored procedure that will be wrong

Posted by Heidi at December 26, 2016 - 8:22 PM

Here to tell you what

Posted by Heidi at December 29, 2016 - 8:34 PM

Estimate is to have bug:

http://support.microsoft.com/viewkb/viewkb.aspx?contentid=2459027

"Index was outside the bounds of the array" SMO error message when you connect to a SQL Server code-named 'Denali' CTP1 Database Engine instance in SSMS 2008 R2 and in SSMS 2008"

It is in connection with SQL server2008r2 and 2008, beyond the bounds of the array index. This is your mistake.

Again this patch: cumulative update SQL Server 2008 R2 5
http://support.microsoft.com/kb/2438347

Posted by Nan at January 06, 2017 - 9:13 PM