CODEWITHSUNDEEP
sqlsql-serverstored-procedures
Roger Reynolds
Roger Reynolds

Reputation: 259

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 procedure?

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

Upvotes: 2

Views: 923

Answers (1)

KM.
KM.

Reputation: 103637

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.

Upvotes: 2

Related Questions