Spectra Developers, Using CF4.5, and spectra 1.5 (not 1.5.1 with updates!!) NT4.0 and MSSQL 7.0.
Apart from the spectra tags, all systems have the correct patches and updates. I have received an error message very similar to the one below. ------- ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]The log file for database '[NAME]_cfaObjects' is full. Back up the transaction log for the database to free up some log space. SQL = "[SOME SQL]" Data Source = "[DSN NAME]" ------- For an object database of 100mb in size the transaction log was 728mb, and filled the disk nearly completely (shared sql server). Also a truncate and then DBCC shrinkfile does not reduce the size of the transaction log, which indicates uncommitted transactions (I think). Has anybody experienced this? I am wondering if it is a spectra issue or some other rogue code that I'm still to uncover. Suggestions/Help is very welcome. Regards, Jared Clinton NEC Australia. ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm ------------------------------------------------------------------------------ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
