We migrated to SQL 7.0 from an Access database about a month ago. We
created the SQL database from the SQL script included with the latest
version, and then imported the data from the Access database.
Since moving to SQL we have experienced several oddities...
First, with ODBC logging turned on, we keep getting errors logged like
ODBC Error:23000:2627:
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY
KEY constraint 'pk_Calls'. Cannot insert duplicate key in object 'Calls'.
ODBC Error:37000:170:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax
near 's'.
Second, about once a week the SQL server goes to 100% processor
utilization. Stopping RadiusNT and Cold Fusion does nothing. It appears
that the RadLogs table may be the problem - deleting the RadLogs table
brings the server back down to realistic CPU utilization.
Thanks in advance...
Mike
--------------------------------
Michael Hobach <mhobach@cyberlynk.net>
CyberLynk Network, Inc.
6214 Washington Ave Suite C16
Racine, WI 53406
(414) 884-1088 Fax (414) 884-1053
http://www.cyberlynk.net