Its a corruption problem in your DB. I don't think its RadiusNT
specific, as I've seen it with other apps as well.
> This problem also prevents me from deleting start records so my db is
> growing by leaps and bounds.
>
> Did a: DBCC checktable (calls)
> and get thousands of lines like these
> Table Corrupt: Keys in data page should be in ascending order; check page
> number 149261
> Table Corrupt: Keys in data page should be in ascending order; check page
> number 197751
>
> I would like to be able to just delete a range of records and keep the
> rest. Is there a way to do this?
>
> If not, and I know this is the easy way out, but at last resort, how do I
> re-name this table and create a new one.
What I would do is Create a Calls2 table (use the Inttabs.sql to grab
the Calls table create statement) and then use a:
Insert Into Calls2
Select * From Calls
Then drop your Calls table and rename calls2 to calls. You will also
need
to re-run the insttrig.sql script and reset perms on the calls table.
--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