Technical Article

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

384 reads

Technical Article

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,402 reads

Blogs

Daily Coping 19 May 2022

By

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

Running dynamic SQL in a different database

By

This is one of those things that on hindsight was a stupid problem, but...

VMware & SQL Server 823-824 alerts

By

We’ve been tracking a weird state with SQL Server virtual machines on VMware and...

Read the latest Blogs

Forums

Create Alert for Number of connection

By Nita Reddy

I have 2 columns , Count and Datetime I need to send alert for...

SQL Query Question

By Siva Ramasamy

Hello everyone, Thank you for looking into my question. I have a dataset like...

"Frankenrows"

By julian.fletcher

I'm not sure if that's the correct term for what we're seeing here, but...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers