开发者

Stored Procedure stopped working

I have a stored procedure that I'm positive of has no errors but I recently deleted the table it references but imported a backup with the same name exactly and same column settings (including identity) that the previous one had but now it doesn't work.

Is there any reason that having deleted the table but importing a new would break the stored procedu开发者_JAVA百科re?

BTW: Running Microsoft SQL Server Express Edition w/ IIS.


you can try to recompile the stored procedure with:

exec sp_recompile YourProblemTableNameHere

this will recompile all procedures that use the YourProblemTableNameHere table. But that is just a guess based on the very limited info given.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜