Server Backup History Report (Full DB Backups only) 1. lists all databases with no backup history 2. lists last backup for other databases includes Date, User, Size, Duration, Age, Finish Date & Location Includes system databases Excludes TempDB Excludes backup history data where backupmediafamily.device_type = 7 these are typically created by Veritas BackupExec Tested on […]
2006-04-28 (first published: 2006-03-23)
4,574 reads
Useful in dev environments when you need to periodically assign execute permissions on all procs in a db (drop/create scripts may have been run without re-assigning permissions)Accepts DB name, ProcLike for matching 'starts with' pattern against proc names in DB, revoke (optional - defaults to 0/True) specifies wheter to GRANT or REVOKE permissions
2002-11-21
383 reads
By Steve Jones
This is my report, which continues on from the Oct report. It’s getting near...
By James-Serra
(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...
By John
Azure SQL offers up a world of benefits that can be captured by consumers...
This script reads thru a file and removes the last line, but before it...
Hello experts, I have a noob question as I never feel like I understand...
Hi all, need your help on conversion of excel formula into case statement. i...
Ask SSC