Click here to Skip to main content
15,905,563 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
I can’t alter or delete stored procedures form tables. Is there something I can do to “unlock” editing ?

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
Share this answer
may be this is permission issue ask DBA for give the permission to the specific user for alter the stored procedure.
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900