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

369 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

834 reads

Blogs

Power Platform Quick Tips – Episode 02: Dynamic Power Apps Form Headers

By

Welcome back to my Power Platform Quick Tips series! In this second episode we...

Simple-Talk Article…Understanding Azure Storage Options

By

Simple- Talk is technical journal and community hub from Redgate. This week I have the pleasure of...

T-SQL Tuesday #120 – Recap

By

The wrap up post for T-SQL Tuesday #120. 9 bloggers contributed this month. The post...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Sql to update active row

By selpoivre

I have below two tables EMpbasetable: Skey,EmployeeNumber,Startdate,EndDate,Active 3,123,2019/06/10,2019/10/27,0 4,123,2019/10/28,4712/12/31,1 EmpIncTable: Skey,EmployeeNumber,Startdate,EndDate 9,123,2019/06/10,2019/10/17 10,123,2019/10/18,4712/12/31 My...

HTML page execute a procedure

By texpic

I have zero front end coding skills; last time I worked with any code...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers