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

Recommended Answers

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

Jump to Post

All 3 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.