[Emerald] Muli database query

Rick Richardson ( rickrich@bossig.com )
Fri, 16 Jul 1999 11:38:57 -0700

I run

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