Click here to Skip to main content
13,053,026 members (61,313 online)
Rate this:
Please Sign up or sign in to vote.
I can’t alter or delete stored procedures form tables. Is there something I can do to “unlock” editing ?
Posted 25-Apr-13 18:32pm
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

There are many different things that could be wrong and without an error message we can’t really give you a specific solution but here are several things I’d try.

Verify permissions – does your account still have same permissions
Verify database is not corrupted – try using DBCC CHECKDB[^] for this
Try restoring database from backup if possible and see if everything is ok there.
I doubt this is the case in your problem but i had many complains lately with similar issues and after extensive investigation we realized SSD hard drives can be the cause. Just wanted to share this for the future readers
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

may be this is permission issue ask DBA for give the permission to the specific user for alter the stored procedure.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100