DBA-Philiac

--Using original Query:   select DB_NAME ( database_id ) as dbname , m . name , m . physical_name , m . type_desc , m . size / 128.0 "Initial Size (MB)" , d . size / 128.0 "current Size (MB)" , ( fileproperty ( m . name , 'spaceused' ))/ 128.0 "Used (MB)" from sys . master_files m , sys . database_files d where database_id = DB_ID() and m . file_id = d . file_id --Using sp_MSforeachdb: exec sp_MSforeachdb N'USE ? select DB_NAME(database_id) as dbname, m.name, m.physical_name, m.type_desc, m.size / 128.0 "Initial Size (MB)" , d.size / 128.0 "current Size (MB)", (fileproperty(m.name, ''spaceused''))/128.0 "Used (MB)" from sys.master_files m, sys.database_files d where database_id = DB_ID() and m.file_id = d.file_id' --Using Cursor:   IF OBJECT_ID('tempdb..#TempTable') IS NOT NULL DROP TABLE #TempTable;  PRINT'check for user database fi

Start/Stop Mirroring EndPoints: ALTER ENDPOINT Mirroring STATE = STOPPED ALTER ENDPOINT Mirroring STATE = STARTED select * from sys.endpoints; select * from sys.database_mirroring_endpoints; SELECT    d.name as 'td','',    mirroring_state_desc as 'td','',    mirroring_role_desc as 'td','',    mirroring_partner_instance as 'td','',    mirroring_role_sequence as 'td','',    case (m.mirroring_witness_state_desc) when 'Unknown' then 'No Witness Server Configured'       else m.mirroring_witness_state_desc end as 'td','' ,    case(m.mirroring_witness_state_desc) when 'Unknown' then 'No Witness Server Configured'       else m.mirroring_witness_name end  as  'td','',    log_reuse_wait_desc  as 'td','' FROM   sys.database_mirroring M inner join SYS.DATABASES d   on m.database_id = d.database_id WH