Interests: My Family, Motorcycles, SQL Server, Motorcycles, Databases, Motorcycles, .Net,

List recovery model of databases.

Script will create a sorted list of databaes and their recvoery model. I'm sure there is a more elegant way to do this, but this works in a pinch.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2007-07-23 (first published: 2006-10-26)

1,095 reads

Blogs

The first version of my accounting assistant could not find a single purchase of...

Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...

I’m really excited about some growth in Flyway support. I’ve been asking about this...

Comments posted to this topic are about the item Pay for Performance, which is...

Hi I have this slow query that is pulling data from a linked server....

Comments posted to this topic are about the item Too Many Choices

I have a table, dbo.MasterBrands, with this data:

BrandID OfficialName
1       Samsung
2       Apple
3       Microsoft
4       Adidas
5       Coca-Cola

I run this query. What is returned for Coca-Cola?

SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel')
FROM dbo.MasterBrands;