Member Avatar for 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

  • 3 Contributors
  • 3 Replies
  • 160 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by crishlay
Member Avatar for debasisdas

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

Member Avatar for 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.

Member Avatar for crishlay

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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.