When you detach a DB and then rename the transaction log file so that it will create a new one (in the case where the xaction log file has grown huge) , Should I check the 'update statistics prior to detach' in order to make sure that any uncommitted transactions getting written to the DB? Also, do the DB options or recovery model have to be set a certain way in order for this to work properly?
Thanks