I am getting the below error on customer production error,
Query timeout expired - State:S1T00,Native:0,Origin:[Microsoft][SQL Server Native Client 10.0]
The queries are forming on the fly using MFC's record sets. if I try to run that queries on SSMS directly I am not getting that error.
How to identify exactly which query leads this error and how to troubleshoot?
I will appreciate your help.