Re: [Emerald] Force CustomerID?, SP to delete users? and error

Dale E. Reed Jr. ( (no email) )
Mon, 20 Sep 1999 09:11:10 -0700

Andrew Stinson wrote:
>
> 1)Is it possible to force the CustomerID when you're inserting information
> into the MasterAccounts table?

Yes. Do a:

SET IDENTITY_INSERT MasterAccounts On

and then do the insert, and do a:

SET IDENTITY_INSERT MasterAccounts Off

when you are done with all the inserts. YOu MUST use a field list when
doing this, though like:

Insert into MasterAccounts(CustomerID, ...) VALUES (x, ...)

> 2)Also, is there some stored procedure setup for deleting users?

No. Do you mean deleting an MBR?

-- 

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