If you are getting rid of ALL data in the table, use the TRUNCATE TABLE command.

Thanks! I knew it was a Dummies question, but it was elusive to me.

I think I found this script on this web site:

--List Table Names and Sizes

declare @id int   

declare @type character(2)   

declare @pages int   

declare @dbname sysname

declare @dbsize dec(15,0)

declare @bytesperpage dec(15,0)

declare @pagesperMB  dec(15,0)

create table #spt_space

(

 objid  int null,

 rows  int null,

 reserved dec(15) null,

 data  dec(15)...

I always use BACKUP LOG DataBaseName WITH TRUNCATE_ONLY

Seems to work great for me.

What about Time zones? I have an Access DB which is 3 hours away. When I add a record and look at the record creation date, it shows me that...