Unable to edit stored procedure using SQL Server Management studio Modify stored proc option

Question

3.67/5 (2 votes)

See more:

Hello Friends
I am facing a problem while right click on stroed proc and click on modify to edit some stored procedure in my database.

I see the error dialog box

Script failed for StoredProducre 'dbo.testproc', (Microsoft.SQLServer.Smo)
Additional Information
Index was outside the bound of the array. (Microsoft.SQLServer.Smo)

but I am able to see the script using sp_helptext

How can I fix this.

Please help.

Posted 26-Dec-13 1:20am

darora85

Add a Solution

Comments

BK 4 code 26-Dec-13 7:23am

Could you please share your store proc here >\?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Answer 1 · 2013-12-26T01:31:00

please see the article

http://support.microsoft.com/kb/2459027[^]

and download a fix for your related sql server version and it will fix the issue..

you can also refer this article for more details on your error and its resolutions please read the comments too..

http://sqlandme.com/2011/05/03/index-was-outside-the-bounds-of-the-array-microsoft-sqlserver-smo-sql-server-denali/[^]

viprat · Answer 2 · 2013-12-26T01:29:00

Solution 1

Hi,

There is installtion proble, here. If you want to edit SP then use command sp_helptext 'stored proc name'. Now you can see the whole SP in result panel. copy that SP in new window and alter your SP and execute it. It will be execute now.

Posted 26-Dec-13 1:29am

viprat

Comments

darora85 27-Dec-13 3:49am

I know this way as mentioned in my description. but i want it via modify option

Christian Graus 27-Dec-13 3:51am

Then you need to fix your installation

Christian Graus · Answer 3 · 2013-12-26T10:15:00

Solution 3

The other possible reason is that you have SS2008 client tools, and a SS2012 database. I had the same error, and this was the issue.

Posted 26-Dec-13 10:15am

Christian Graus

Comments

darora85 27-Dec-13 3:50am

client tools and db has same version.

Christian Graus 27-Dec-13 3:51am

That's odd, then it's just hosed.

Unable to edit stored procedure using SQL Server Management studio Modify stored proc option

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us