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)

2006-04-28 (first published: )

4,575 reads

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

2002-11-21

386 reads

Blogs

Azure SQL Database – Contained user Model

By

I always follow a contained user model when setting up users within my Azure...

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Wait for query to finish before returning results

By oRBIT

When I do "select * from ... " from a large table, the result...

Reading a Specific File from an S3 bucket Using Python

By prashant239

Comments posted to this topic are about the item Reading a Specific File from...

Distributed SQL Databases

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Distributed SQL Databases

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers