Click here to Skip to main content
Rate this: bad
good
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 19:32pm
Rate this: bad
good
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.
Update:
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
  Permalink  
v2
Rate this: bad
good
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.
  Permalink  

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

  Print Answers RSS
0 BillWoodruff 300
1 Mathew Soji 274
2 Afzaal Ahmad Zeeshan 268
3 DamithSL 225
4 Sergey Alexandrovich Kryukov 205
0 OriginalGriff 6,249
1 Sergey Alexandrovich Kryukov 5,853
2 DamithSL 5,183
3 Manas Bhardwaj 4,673
4 Maciej Los 3,865


Advertise | Privacy | Mobile
Web01 | 2.8.1411019.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2014
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