Technical Article

Server Backup History Report (updated 2006-04-11)

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 […]

4.67 (3)

You rated this post out of 5. Change rating

2006-04-28 (first published: )

4,577 reads

Technical Article

Grant/Revoke EXEC permissions  for all procs in DB

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

You rated this post out of 5. Change rating

2002-11-21

387 reads

Blogs

Migrating from EverNote to Joplin

By

Recently I got a message that my Evernote subscription was going up. It’s been...

Using Data Masker on Chinese Surnames

By

A customer had a question recently on masking Chinese characters. I thought that was...

A New Word: Looseleft

By

looseleft – the feeling of loss upon finishing a good book, sensing the weight...

Read the latest Blogs

Forums

Scaling Up Monitoring

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Scaling Up Monitoring

Database Sequence Objects with dbatools

By Mikey Bronowski

Comments posted to this topic are about the item Database Sequence Objects with dbatools

Why a monitoring tool is an essential tool for growing server estates

By Site Owners

Comments posted to this topic are about the item Why a monitoring tool is...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers