Hi -

19.0, MS SQL back end, DAW driver, using SQL Connection.

One table, a system file, cannot be refreshed - as when we do, it simply closes the studio. However it does change the INT. This is only happening on one machine & on this one table. I can refresh the table on my machine with no problem, the other machine can refresh anything but this table.

Looking at the table in SSMS shows that both machines are identical as far as structure & index goes.

The INT from my machine (where it works) looks like this:

Code:
DRIVER_NAME MSSQLDRV
SERVER_NAME DFCONNID=Star
DATABASE_NAME emailsig
SCHEMA_NAME dbo

RECNUM_TABLE YES
PRIMARY_INDEX 0
GENERATE_RECORD_ID_METHOD IDENTITY_COLUMN
SYSTEM_FILE YES
TABLE_CHARACTER_FORMAT ANSI
USE_DUMMY_ZERO_DATE YES

FIELD_NUMBER 1
FIELD_LENGTH 16383

FIELD_NUMBER 2
FIELD_LENGTH 16383

INDEX_NUMBER 0
INDEX_NAME PK_emailsig_Recnum
When he clicks Refresh, before the studio closes, it changes the INT to:

Code:
DRIVER_NAME MSSQLDRV
SERVER_NAME DFCONNID=Star
DATABASE_NAME emailsig
SCHEMA_NAME dbo

SYSTEM_FILE YES
GENERATE_RECORD_ID_METHOD IDENTITY_COLUMN
TABLE_CHARACTER_FORMAT ANSI
USE_DUMMY_ZERO_DATE YES

INDEX_NUMBER 0
INDEX_NAME PK_emailsig_Recnum
The app errors if run on this INT.

Any one have any ideas what's going on? We've replaced the INT & FD with copies from my (working) machine - still happens.