In my application some stored procedures are not working properly in current database of SQL Server.
I have taken backup of database 2 weeks ago and all stored procedures are working in backup database.
I have checked the properties of current database and backup database both are same.
After restoring the backup all procedure are working properly but in current database some procedures are not working.
Could anybody can help me to solve this problem.
Thanks in advance.