I am getting the error
[Microsoft][Sql Server Native Client 11.0]
Query timeout expired
on SQL Server via ASP page. Most of the time it is working fine but sometimes I am getting this error. Can anyone tell me If this a SQL Server issue or ASP.NET issue?
I have run the same query in SSMS, it completed within seconds. ASP page can query anything. I am using
sa user for auth, so I think it has full permissions.