I’m trying to export query from my local storage . I would need to create an automation process to be done each week for this query.
After 10 min run I get Error:" Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.’
I tried to run the query in editor and it is done after 5 min.
I tried to increase timeouts times to 9999 at Tools->option->database->Timeouts. - still received the same error
I also restarted the computer - still received the same error.
I tried to export with “Select to File” and the query populated the file correctly.
would you please advice and additional action that can be done.