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

376 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,034 reads

Blogs

More Azure Blob Storage enhancements

By

I recently blogged about Query Acceleration for ADLS, which also applies to Azure Blob...

Daily Coping 25 May 2020

By

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

A Byte of Redgate–Bonus Queso Recipe

By

As part of the Community Circle effort at Redgate, we’ve released a cookbook: A...

Read the latest Blogs

Forums

HTML Mail with more than one line in Resultset

By tutter

Hello all, i would like to send a html Mail with sql server. But...

AS Tabular and Sample Data in VS

By philipp

Hello all, I really need your help – I want to use the sample...

SSIS Export Flat File as Fixed Width

By Oscar_Boots

Hi Forum, I have a table that uses the script below to create fields...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers