SQL Server 2005 – Create backup script for all user databases

— Create backup script
— MDaponte – 2010-09-15

set nocount on

declare @Dir as varchar(100)
set @Dir = ‘E:\MyBackups’
–print @Dir

declare @DT as varchar(16)
set @DT = replace(replace(replace(convert(char(16), getdate(), 120), ‘-‘, ”), ‘:’, ”), ‘ ‘, ‘_’)
–print @DT

select ‘backup database ‘ + name +
       ‘ to disk = ”’ + @Dir + ‘\’ + name + ‘_db_’ + @DT + ‘.bak” with format ;’
  from master..sysdatabases
 where name not in (‘master’, ‘tempdb’, ‘model’, ‘msdb’, ‘ReportServerTempDB’)
 order by dbid

Hidden caller ID

*67 (star six seven)

but…

*67 does not work on many wireless carriers, instead, try using the GSM standard code, #31# to block, or *31# to display if hidde