-- As one other forum member said, the time in a datetime column is stored --- as a decimal. The trick in the code below simply truncates the decimal

--

--...

I don't think that jobs (SQL Server Agent jobs, i presume) take parms. (If I'm wrong, someone slap me silly and let me know...)

Here's how a user (via...

Ah, I found someone else who fell for the "File has been written to since last backup" flag ... Wouldn't that be nice?

There may be a compromise...

"SELECT * FROM ::fn_virtualfilestats(dbid,dbfile_id)"...

Most likely you have an application that opens a transaction for updates, inserts, deletes, etc. and doesn't close the transaction for a long time. BCP operations can do this. Also,...

we have a situation similar to yours. if there's truly a hard file copy (or ftp) lock down, i guess you have to proceed with your sql-based solution: i don't...