Here is an SQL that you can run to find the total used size of an SQL Server 2008 database instance: CREATE TABLE #t (name SYSNAME, rows CHAR(11), reserved VARCHAR(18),    data VARCHAR(18), index_size VARCHAR(18), unused VARCHAR(18))   exec sp_MSforeachdb ‘      use [+];       if (select DB_NAME())<> ”tempdb”          begin   [...]

Bill Graziano at SQLTeam.com has a listing of all the SQL Server versions that come in very handy: http://www.sqlteam.com/article/sql-server-versions

This is an update to a previous post (Shrink All Log Files Within A MS SQL Instance) that has been edited to work in SQL Server 2008. <br /> declare @ssql nvarchar(4000)<br /> SET @ssql= ‘<br />     if ”?” not in (”tempdb”,”master”,”model”,”msdb”)<br />         begin<br />         [...]