RogerCooper
Registered User.
- Local time
- Today, 07:29
- Joined
- Jul 30, 2014
- Messages
- 288
Each day, I run a long series of queries, the results of which are e-mailed. Sometimes, most of the SQL code in the query disappears after sending the e-mail. All that remains is the first clause such as "SELECT DISTINCTROW TOP 7" while all the remaining code is gone. The e-mail itself has the correct data.
This is long-standing problem, but it has been getting worse lately. I keep a table that has all the SQL code for queries so I can restore it easily, but it would be better if I did not need to do so. I repair/compact daily.
Does anyone know anything about this bug?
This is long-standing problem, but it has been getting worse lately. I keep a table that has all the SQL code for queries so I can restore it easily, but it would be better if I did not need to do so. I repair/compact daily.
Does anyone know anything about this bug?