In the process of searching out all of the sp's that contain "select into". In the meantime, due to nonlogged transaction, we cannot backup trans log. Must exec full backup. Is there a way around this? Can you locate and clear out nonlogged trans prior to executing backup?