Patty Dunbar

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

908 reads

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

Blogs

Upgrading SQL Server 2017 Containers to 2019 non-root Containers with Data Volumes – Another Method

By

Yesterday in this post I described a method to correct permissions when upgrading a...

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...

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...

Kill 2 databases connections

By Tac11

Hi Gurus, Below script kills the only connection related to the AdventureWorks databases. If...

Previous Day (Business Day Only) Needed for Auto Tableau Server Script

By earthdice

Hello, Need a simple script that would pull back the previous business days' assigned...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers