TRUNCATE TABLE does get logged...minimally. The page deallocations are logged. It can also be rolled back in a transaction. The database log needs to be truncated/backed up. Look for the Andrew Zanevsky script sp_force_shrink_log also:
http://www.davidpenton.com/testsite/scratch/sp_force_shrink_log.aspx David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript SQL BOL: http://www.davidpenton.com/sqlbol -----Original Message----- From: Bostrup, Tore [mailto:[EMAIL PROTECTED]] Well, it sounds like the logfile actually does fill up when you delete all the records in the table, since each deleted row gets logged. You could try to issue a "truncate table" statement instead. AFAIK, that will not log the deleted rows to the transaction log. If you really need to issue the delete statement, you can adjust the size (restrictions) of the Transaction Log file, by selecting the db in EM ("MMC") and selecting Properties. Go to the Transaction Log tab and see whether there are any restrictions on the file growth. You may also need to determine whether there is space available on the appropriate HD. You can also add another logfile by simply typing in the blank row. This requires that you have appropriate privilege on that (your) database, of course. HTH, Tore. PS: Drop the ";" at the end of the statement also. -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] Sorry, i actualy added them in when writing the mail. so it ooks like this: DELETE FROM copies; any ideas? Thanks Tim -----Message d'origine----- De : Bostrup, Tore [mailto:[EMAIL PROTECTED]] drop the single quotes from around the table name: delete from tablename HTH, Tore. -----Original Message----- From: Tim Fletcher [mailto:[EMAIL PROTECTED]] when i execute the following sql query "delete from 'tablename';" i get the following error Serveur�: Msg 9002, Niveau 17, �tat 2, Ligne 1 The log file for database 'adpfas' is full. Back up the transaction log for the database to free up some log space. the problem being that i have not got access to the server exept through th SQLServer MMC, and i have no rights on the master DB or any admin tasks. Thanks for your time Tim ps: i've just started receiving mails again, whats happening? Cheers --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
