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