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

Andrew Stinson ( (no email) )
Mon, 20 Sep 1999 12:08:16 -0500

Yes, sorry for being vague on that....a stored procedure to delete the MBR,
subaccounts, calls and everything for that user when we no longer need that
information...(i'm wanting a SP to do it so we could modify it to run and
delete users with certain columns containing certain data....)....
_____________________________________________________________________
Andrew Stinson
astinson@apex2000.net
Apex 2000 Internet Services Corporation Phone: (915) 570-1676

----- Original Message -----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: <emerald@iea-software.com>
Sent: Monday, September 20, 1999 11:11 AM
Subject: Re: [Emerald] Force CustomerID?, SP to delete users? and error

> 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
>

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