I have some longer running SQL queries that exit due to a timeout. Is there a way I can increase the timeout in my Lua script?
Where are you getting the timeout? If it's coming from NAS GUI, then it's likely just the GUI timing out waiting for the script. You could have your script log in the NAS log and check if output keeps appearing there event after the timeout.
I know from some other languages that they have query and connection timeout properties for SQL commands. According to NAS documentation it doesn't seem like there's one implemented.
It could also be an issue with the SQL server, you could check out this link http://technet.microsoft.com/en-us/library/ms177457%28v=sql.105%29.aspx
Retrieving data ...