Thanks to everyone who replied and offered help with creating and modifying the query. I just began supporting SQL Server, coming from DB2 mainframe DBA.

Thanks again for all the help

Charles...

Thank You Dan for the help. Could you also help me in modifying the report to include all columns for each table.

Thanks again, I really appreciate the help!

Or this might...

Hi,

Last Sunday I shrinked a transaction log from 15GB to 1GB. I did the following:

1. Backup of transaction log

2. Ran DBCC Shrinkdatabase with TRUNCATEONLY option

You can find useful help in...