Script to determine backup finish times

SQL Server provides the RESTORE HEADERONLY command which helps users determine backup completion times.  What if you have the need to use this completion time for comparison, perhaps to set up a job that only restores the file if it is xx hours old.  This script can be used to determine the maximum backup finish […]

2002-12-04

383 reads

Dependencies on a specific table column

SQL Server provides a built-in stored procedure, sp_depends, that returns object dependencies.  Recently, I discovered a need for determining dependencies on a table column, not just the table itself.  For example, a table may be referenced by many stored procedures and views, but a specific column in that table may only be referenced in a […]

5 (1)

2002-12-03

1,212 reads

Blogs

The Diverse Data Platform–Dativerse.io

By

The other day I got a note from Ben Weissman the other day that...

Extended Events and Azure SQL Database

By

Knowledge of how your system behaves is vital to better control, maintain, and grow...

Daily Coping 19 Apr 2021

By

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

Read the latest Blogs

Forums

Replication - not all columns are updating

By screenshot

I've set up replication but I'm having difficulties in my testing. I've changed 3...

The Security of Source Code

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Security of Source Code

Running SSIS in ADF

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Running SSIS in ADF

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers