I am running a SQL2000 Server. I have a programmer that recently wrote a stored procedure that inserted hundreds of rows 1,000 of times. The end result of this was the growth of my log to 3GBs for this specific database..... With SQL a log or DB file can never be decreased in size, only increased. I want to resize this file to 100mb but can't figure out how to do that.... I have read that I can simply delete the log file and it will regenerate to the original size that is was created as. Is this correct or is there another way I can do this? Any help or advice would be appreciated

Thanks!!!!