We have a big application in C# and SQL Server. The SQL Server team is doing the changes in the Stored Procedures which were not communicating to Application Development team. Perhaps It is causing the application break. Can someone please suggest me the possible ways,
1. How to write a C# programme to be notified of these changes?