且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

无法在SQL 2005中更改存储过程

更新时间:2023-01-22 17:24:10

有许多不同的东西可能是错的,没有错误信息我们无法真正给你一个特定的解决方案,但这里有几件事我会尝试。



验证权限 - 您的帐户是否仍具有相同的权限

验证数据库是没有损坏 - 尝试使用 DBCC CHECKDB [ ^ ]这个

如果可能,请尝试从备份中恢复数据库并查看如果一切顺利的话。

更新:

我怀疑你的问题就是这种情况,但我最近有很多抱怨类似问题,经过广泛调查后我们意识到SSD很难驱动器可能是原因。只是想为将来的读者分享这个
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


可能是这是权限问题请DBA给予特定用户更改存储过程的权限。
may be this is permission issue ask DBA for give the permission to the specific user for alter the stored procedure.