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

Get Configuration Change History From the SQL Server Error Logs

By

Get Configuration Change History From the SQL Server Error Logs There...

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Read the latest Blogs

Forums

Managing some particular dimensions in a data warehouse based on medical records

By pmscorca

Hi, I need to design a data warehouse solution to manage medical records about...

Gentlest of Reminders, Don't Stop Learning

By Grant Fritchey

Comments posted to this topic are about the item Gentlest of Reminders, Don't Stop...

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers