Very Computer

I have a Table - where every INSERT/MODIFIY/DELETE is copied to a "history
table"
that table has the same struktur as the main table!
If i delete or insert any fields of table i always get the error:

******************************
'RootCodeMT' table saved successfully
'CodeMT' table
- Unable to preserve trigger 'tr_OnUpdateNewCode'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error:
Column name or number of supplied values does not match table definition.
*****************************

first the table isn't saved ... and the best ----> near all referencies to
or from that table are deleted from the diagrams
what can i do to get them all back - without new-create them!

best regards
-Brisi

Thomas,

My guess is that the tool which you modify the table chokes on the complexity (EM
creates a new table copies columns etc etc etc).
Try using straight TSQL (ALTER TABLE ADD/DROP...).

--
Tibor Karaszi, SQL Server MVP
Please reply to the newsgroup only, not by email.

Quote:> Hi!

> I have a Table - where every INSERT/MODIFIY/DELETE is copied to a "history
> table"
> that table has the same struktur as the main table!
> If i delete or insert any fields of table i always get the error:

> ******************************
> 'RootCodeMT' table saved successfully
> 'CodeMT' table
> - Unable to preserve trigger 'tr_OnUpdateNewCode'.
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Insert Error:
> Column name or number of supplied values does not match table definition.
> *****************************

> first the table isn't saved ... and the best ----> near all referencies to
> or from that table are deleted from the diagrams
> what can i do to get them all back - without new-create them!

> best regards
> -Brisi