I've been playing around with queries against a test SQL Server database on my laptop, and noticed that the transaction log is currently about 850 MB.
I'd like to delete the log, since I don't need it, but obviously don't want to delete the tables themselves.
When I try to delete the log in Enterprise Manager, I get an error saying that I can't delete the primary log.
Any idea how to do this?
Thanks,
Kevin