I have this query (which uses linked server as well) runs fine in SQL Server Management Studio (local and remote) but when run in Stimulsoft, it times out. It takes under 5 seconds to run in SSMS but times out in Stimulsoft each time. I did increase timeout period to 90 but still has this issue. I am not sure what is the problem?
exec SPR_HRM_GetSalaries @FromDate=’01-Jun-15′, @ToDate =’25-Jun-15′