Click here to Skip to main content
11,637,176 members (59,772 online)
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 18: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 OriginalGriff 295
1 stibee 288
2 jyo.net 270
3 Sergey Alexandrovich Kryukov 214
4 himanshu agarwal 184
0 OriginalGriff 9,031
1 Sergey Alexandrovich Kryukov 8,513
2 Mika Wendelius 6,922
3 F-ES Sitecore 2,388
4 Suvendu Shekhar Giri 2,320


Advertise | Privacy | Mobile
Web02 | 2.8.150728.1 | Last Updated 3 Jul 2013
Copyright © CodeProject, 1999-2015
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