Monday, October 22, 2012

Uncommitted transactions causing timeout error

The timeout period elapsed prior to completion of the operation or server is not responding

@@TRANCOUNT helped identify uncommitted transactions and the issue was resolved.

WHILE @@TRANCOUNT > 0
BEGIN
  COMMIT;
END;


No comments:

Post a Comment