> I have an SQL.log file that has grown to approx 2GB. How do > I reset the options for this file/Delete it? I have looked > in the SQL manager, but cant seem to find were the settings > are. I would like to limit what is being logged and to decrease > the size of the file itself.
If you're using SQL Server 7.0, you can set the "truncate log on checkpoint" option within the database's properties dialog. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
