Add this before/After:
SET IDENTITY_INSERT Emerald2..SubAccounts ON
> insert into emerald2..subaccounts
> select * from subaccounts
> where accounttype = 'ISDN - 128k'
SET IDENTITY_INSERT Emerald2..SubAccounts OFF
> 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
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart