Stored Procedure error in sql 2005

[sels2005j]

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

[debasisdas]

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

[sels2005j]

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.

[crishlay]

possibility of database tables corrupt may cause stored procedure execution problem