> Just load checkdb.sql into isql_w and execute it against your Emerald
> database. The checkdb.sql that comes with Emerald will work fine for
> you. I did put the newest one in /emerald/updates a few minutes
> ago. The only difference is that it includes a section at the
> bottom to update all of your indexes as well.
Just ran this new .sql and it gives me this,
DBPROCESS is dead or not enabled.
The total number of data pages in this table is 1.
DBCC CheckDB
---------------
Attempt to initiate a new SQL Server operation with results pending.
Changed database context to 'Emerald'.
DBCC NewAlloc
---------------
DBCC execution completed. If DBCC printed error messages, see your
System Administrator.
Updating SERVERTYPES
Updating SYSTEMTYPES
Updating TAXES
Updating TRAFFIC
Updating WINDOWOBJECTS
Updating WINDOWS
Updating DNISNUMBERS
Updating GROUPS
Updating OBJECTS
Updating OPERATORS
Updating RADATTRIBUTES
Updating RADLOGS
Updating SCRIPTMAPS
Updating SERVERS
Updating BILLINGCYCLES
Updating CHARGETYPES
Updating CLASSES
Updating DISCOUNTS
Updating INVOICETYPES
Updating MAILITEMS
Updating MASTERACCOUNTDATATYPES
Updating OPERATORGROUPACCESS
Updating PAYMENTTYPES
Updating PAYMETHODS
Updating PAYPERIODS
Updating RADREJECTS
Updating RADVALUES
Updating REGIONS
Updating SERVERPORTS
Updating ACCOUNTTYPES
Updating CLASSDATES
Updating MASTERACCOUNTS
Updating GROUPACCESS
Updating INVOICES
SQL Server connection timed out.
Updating MAIL
Updating MASTERACCOUNTDATA
Updating PAYMENTS
Updating RADATCONFIGS
Updating RADROAMDOMAINS
Updating SERVERACCESS
Updating SUBACCOUNTDATATYPES
Updating SUBACCOUNTS
Updating BANKTRANS
Updating ALIASES
Updating CALLS
Command has been aborted.
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html