Thanks for all the tips. I know it is not a timing issue, because I can enter debug and wait as long as i wish, it still will not find...

It also may be a mapped drive problem. When you run a DTS package from your system, it runs on your system and uses your client's mapped drives. The server...

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...