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,571 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 damianwidera
This is the second article in the Machine Learning area. I have explained a...
In this article, we will focus on creating a data pipeline to ETL (Extract,...
By HamishWatson
So in January I wrote a blog post on some goals I had this...
Dear All, I have a DB on which TDE is enabled. When trying to...
I am trying to install SQL Server 2017 Enterprise Edition. It is an Iso...
Hi, hope someone can help with this. I've the table gifts_to_give: Id_give number_of_gifts name ...
Ask SSC