insert into emerald2..subaccounts
select * from subaccounts
where accounttype = 'ISDN - 128k'
with the emerald db selected in the query dialog
and i get this message:
Msg 8101, Level 16, State 1
An explicit value for the identity column in table
'emerald2..subaccounts' can only be specified when a column list is used
and IDENTITY_INSERT is ON
--R. L. Richardson III
http://www.aempires.com"The reasonable man adapts himself to the world;the unreasonable man persists in trying to adapt the worldto himself. Therefore all progress depends on the unreasonable man."
- George Bernard Shaw
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart