• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1238
  • Last Modified:

SQL 2008R2: When opening SP, errmsg --> Index is outside of the bounds of the array. (Microsoft.SqlServer.Smo)

Hi all

I'm attempting to do a right-click:Modify on a Stored Procedure, and instead of opening it as a new query it returns the following error messageerrmsgThe database in question is a third party vendor (Maestro)'s implementation of Master Data Services, in case that helps.

SQL 2008 R2 (v10.10.1600.1).  Some sites I have searched off of Google say to just increase to the most current version, but don't provide any other meaningful info.

Thanks in advance.
Jim
0
Jim Horn
Asked:
Jim Horn
2 Solutions
 
lcohanDatabase AnalystCommented:
"Some sites I have searched off of Google say to just increase to the most current version, but don't provide any other meaningful info. "

I suggest you apply the SQL 2008 R2 SP1 on both the SQL server and on your SQL SSMS  - that's right, client computer tools must be upgraded not just SQL server.

See below the version numbers associated and make sure your SSMS was updated as well.

http://support.microsoft.com/kb/321185
0
 
David ToddSenior DBACommented:
Hi,

I got this error today when opening Object Explorer in SSMS 2008R2 against a SQL 2012 server.

HTH
  David
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
At the moment I'm unable to troubleshoot this, as my current screwy-riffic client does not wish to experiment with installing drivers and service packs.  So ... I'll award points for assistance that looked like it would have led to a solution, and back off gracefully.  -Jim
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now