Patty Dunbar


Technical Article

Full, diff and tlog backups based on recovery mode

    This a script which creates stored procedures that can be executed adhoc or set as sql agent jobs to check the recovery status and generate full, differential or transaction log backupf for each database if the database recovery status is set to full.  We have terabytes of data and set all production databases […]

2003-06-06

916 reads

Technical Article

Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

2001-08-27

3,105 reads

Blogs

Being a script magpie

By

Last month (I ran just a little bit late writing this, it was meant...

Community Tools Month 2022 - dbatools

By

The Prompt In July, Brent Ozar (blog | twitter) asked us to make September...

Storytelling with Data – Enertia User Conference 2022

By

Thank you to everyone who attended my session at the Enertia User Conference in...

Read the latest Blogs

Forums

Missing weekend data to Zero

By LearnSQL

Hi All, I have a requirement that if there is no weekend data then...

How to calculate orders historically, during month

By Zond Sita

Good Morning There, CREATE TABLE Customers ( CID int NOT NULL PRIMARY KEY, GroupName...

How Important is Software?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Important is Software?

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers