Re: [Emerald] Muli database query

Dale E. Reed Jr. ( (no email) )
Fri, 16 Jul 1999 11:36:04 -0700

Rick Richardson wrote:
> 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

Also, you have to add a column list (yeah, its a pain) like:

> insert into emerald2..subaccounts(AccountID, Login, Shell, Password, ...)
> select AccountID, Login, Shell, Password, ...
> from subaccounts
> where accounttype = 'ISDN - 128k'

You might have to be in the Emerald2 database and fully reference the
Emerald database, as I don't know if you can do an IDENTITY_INSERT on
a table outside the current DB.


Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc.

For more information about this list (including removal) go to: