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.

Joseph

It is really difficult to guess what is happening in your system blindly.

It is really difficult to guess what is happening in your system blindly.

thanks for your reply.

i have solved the problem. The database table was corrupted.

possibility of database tables corrupt may cause stored procedure execution problem