Hot answers tagged sql
It seems you are putting a heavy load on the server and that cannot be handled by the SQL Server itself. I would suggest splitting it into chunks, executing one by one and also increase the timeout to something relatively better for the particular query. I think it is ok to increase timeout upto 90 seconds depending on the situation and then can rollback ...
Only top voted, non community-wiki answers of a minimum length are eligible