MSSQL 6.5 sp5a
RadiusNT 2.5.161 - I have had this problem for years so I don't think it is
version specific.
I have a problem with my RadiusNT SQL Calls table, looks like I have about
50 thousand corrupt records in the middle of the "calls" table. Any one
else using RadiusNT having these problems? Is this a problem with the way
RadiusNT writes to the db, or is it a problem with M$?
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.
Thanks for all of your help.....
JOhn :}
John C. Lange, Sr. PALACE dot NET, INC.
microjl@palacenet.net MICRO-TECH Computers, Inc.
608.742.1601 & 6980 1819 New Pinery Road
http://www.palacenet.net/ Portage, WI 53901
MSCE Training for only $150.00 - http://dpec.palacenet.net/
All 200+ Web Based Courses for $150.00 Per Year - Really
--- __o
--- _-\<,_ Fastest Service in Town
--- (_)/ (_)
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart