[CF-Database] Problem with inserts

["Russ Michaels \(Snake\)" <snake.lists@snakepit.net>]

I have a database where all inserts are giving me errors like this.

 [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name
'cfmx_helpdesk.ticketdata'.

Cfmx_helpdesk is the DBO for all tables and has "database owner"
permissions. Selects and updates work fine.

I really dunno why it is trying to reference the tables as USER.TABLE just
on inserts, as this is not in the code.

I have recently changed this database to that the above user is the DBO
instead of SA.

Any ideas?


Russ