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
> and IDENTITY_INSERT is ON

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.    www.iea-software.com

For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart