121 reputation
4
bio website
location
age
visits member for 1 year, 4 months
seen Sep 11 at 4:41

Sep
9
comment MYOB ODBC crashes SQL Server
@James Yes, I am aware of that, I am getting the updates now.
Sep
9
revised MYOB ODBC crashes SQL Server
added log entry for further clarification
Sep
9
comment MYOB ODBC crashes SQL Server
Hi @James, I cannot access 32-bit ODBC using 64-bit SQL Server though, that's not what I'm trying to do. I will add an event log entry (the only error log entry I get) and try a more recent update to see if that fixes any issues.
Sep
8
asked MYOB ODBC crashes SQL Server
May
21
awarded  Popular Question
Aug
1
accepted Restore to last transaction log restore
Aug
1
comment Restore to last transaction log restore
Thanks, much appreciated. We decided in the end to just update the secondary database when the need arose. We actually tried replication but it almost broke the production AX instance, which makes changes to the DDL periodically.
Jul
20
awarded  Editor
Jul
20
revised Restore to last transaction log restore
Rephrased my question
Jul
5
asked Restore to last transaction log restore
May
8
awarded  Student
May
7
awarded  Scholar
May
7
comment Cannot rebuild index, but there's no reason why not?
There we go. That was just what I needed to hear. Seems the devil was in the details - 'MEMO' was not a column type, but a column of the table - which is of type ntext. I feel a bit of a fool, but at least I've learned something. Thanks @Justicator.
May
7
accepted Cannot rebuild index, but there's no reason why not?
May
7
comment Cannot rebuild index, but there's no reason why not?
Thanks Kenneth. I added those to the query, and still got no results. Now, since it is perfectly clear that there are no MEMO type fields, no MAXed character fields and no spatial fields, we can eliminate that as a cause for this error. Which leaves me with the question - what else could be causing this to fail?
May
7
comment Cannot rebuild index, but there's no reason why not?
@swasheck If I was doing that, it would by c.system_type_id NOT IN in that query.
May
7
asked Cannot rebuild index, but there's no reason why not?