Technical Article

Quickly Reveal DB Recovery Model on all Databases.

I wrote this little tool out of the frustratingly slow process one must endure to find out what database Recovery Model your SQL 2000 databases are currently set to. This tool will quickly reveal whether your database Recovery model is set to either "Simple", "Full", or "Bulk-Logged." Who has time to manually pull up "Properties" […]

4 (1)

You rated this post out of 5. Change rating

2007-05-03 (first published: )

772 reads

Blogs

The 5 Best SQL Course for Beginners – Reviews and Guide

By

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...

Speaking at SQL Saturday Boston 2023

By

I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...

Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray

By

In this series of blog posts, we’re diving into how to use the Pure...

Read the latest Blogs

Forums

temp table filtering with Joins question

By sqlguy80

Hello Gurus for one use case we converted the code to use temp tables...

checkdbcc date for all database

By lan2022nguyen

CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...

Azure Postgres reliability/management experiences

By CreateIndexNonclustered

I am considering implementing an Azure Postgres DB for use in a part of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers