René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"TransactionScope timeout","articleBody":"When running queries that take a long time (e.g. creating an index on a large table) we are getting timeouts:\n\n_Failure: The transaction associated with the current connection has completed but has not been disposed. The transaction must be disposed before the connection can be used to execute SQL statements.\nErroring script was run in a transaction and was rolled back._\n\nWhen running the same query using --NOTRANSACTION it does not time out. This leads me to believe that the TransactionScope is timing out. Further reading revealed that TransactionScope has a hidden timeout setting of 1 minute (which corresponds to the timeouts that we are seeing).\n\nI noticed that you increased the SqlCommand timeout to infinite in an earlier change. Would it be prudent to do the same for TransactionScope?\n","author":{"url":"https://github.com/louiskruger4c","@type":"Person","name":"louiskruger4c"},"datePublished":"2016-05-10T07:13:13.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/17/AliaSQL/issues/17"}