datetime2?

why not just expand datetime to be more precise expecially if earlier comments are correct that it will take 8 bytes (i.e. no difference in storage space)?

seeing the poster mentioned starting over, getting the space back, etc., the following three T-SQL statements will do just that.

--this discards the log

backup log [MyDatabase] with no_log

--this shrinks the database...

1. Check available hard drive space on the server drives.

2. Also, if you are running databases in full recovery mode, a database backup does not mark the log file for...

Nice stored procedure to kill processes but I don't understand when you would use it?

If you need everyone out of a database and need them to stay out, then I'd...

If the database is in full recovery mode and you haven't backed up the transaction log, shrinking won't be able to do anything because SQL Server will not discard any...