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,572 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

383 reads

Blogs

Interview with Greg Low

By

This is the sixth interview we have done. This time our guest is Greg...

Azure SQL Database Types

By

I want to do a quick summary post of the many different types of...

Azure SQL Database – Azure Portal Updates

By

A small but useful change has been made to the Azure Portal for Data...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Which items can be built (do we have enough product for)?

By pietlinden

I have a stupid question. I'm dealing with a Bill Of Materials problem... I...

Modifying the Dataframe in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Modifying the Dataframe in R

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers