Monthly Archives: June 2009

Table size in all DBs

create Procedure Mu_TableSizeas if object_id(‘TableStorage’) is  null  –drop table TableStorageCREATE TABLE  TableStorage( [ServerName] [nvarchar](128) NOT NULL, [DatabaseName] [nvarchar](128) NOT NULL, [TableName] [nvarchar](128) NOT NULL, [RowCount] [bigint] NULL, [TotalSpace] [bigint] NULL, [DataSpace] [bigint] NULL, [IndexSpace] [bigint] NULL, [UnusedSpace] [bigint] NULL, [DateInfoCollected] [datetime] NULL) declare @command1 varchar(500), @command2 varchar(500), @command3 varchar(500), @replacechar … Continue reading

Posted in SQL Server 2005 Scripts | 100 Comments

Burn an ISO-image to CD or DVD

Many people asked me how to burn the cd or dvd from ISO files downloaded from MS site for software installations….   "Windows Server 2003 Resource Kit Tools"   Download rktools.exe and install it.   Steps to burn … Continue reading

Posted in Computers and Internet | 63 Comments