Test Results to check MS SQL CommandTimeout
- [Get_AuditTrailOCMReport] stored procedure added delay for 5 minutes.
WAITFOR DELAY '00:05';
- SQLCOMMANDTIMEOUT set to 2 seconds
- Command is timedout after 2 seconds
- SQLCOMMANDTIMEOUT set to 10 seconds
- Command is timedout after 10 seconds
- SQLCOMMANDTIMEOUT set to 120 seconds
- Command is timedout after 120 seconds
- [Get_AuditTrailOCMReport] stored procedure removed delay for 5 minutes.
- SQLCOMMANDTIMEOUT set to 120 seconds
- Command executed suscessfully within a seconds
