检索存储过程的先前版本 [英] Retrieve previous version of a stored procedure

问题描述

我今天修改了一个存储过程，但后来我意识到它是错误的.所以我想把它恢复回来.有什么办法可以得到以前修改过的存储过程或上次日期的存储过程.我也没有任何备份.谢谢.

I have modified a stored procedure today but after that I realized that it is wrong. So I want revert it back. Is there any way to get the previously modified stored procedure or else last date's stored procedure.I don't have any back up also. Thank you.

推荐答案

不直接在 SQL Server 中.除非您在源代码控制或其他地方保留了脚本，否则您唯一的选择是将旧备份恢复到另一个环境，然后从该环境中编写旧版本的脚本.

Not directly within SQL Server. Unless you have kept a script in source control or elsewhere your only option is to restore an older backup to another environment and script out the old version from that.

这篇关于检索存储过程的先前版本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！