This is just a quick method to determine the backup mode of all databases on a server. No cursor involed.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-05-18 (first published: 2007-05-07)

429 reads

Discuss

Find the database by table name

by jmcgarvey

SQLServerCentral

Miscellaneous

Here's the scenario: 1. You have been given a script to run.2. You do not know the database name.3. You know which server.Substitute the word "TABLENAME" with the table name in the script and run in query analyzer. This query will check every database on the server and return the name of the database with […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2007-04-26 (first published: 2007-04-04)

485 reads

Discuss

All authors

Blogs

Learning from Mistakes: T-SQL Tuesday #194

By Steve Jones

We’re a week late, once again my fault. I was still coming out of...

Stupid Things I Did With AI: ASCII Art

By Steve Jones

I ran across this article recently (https://www.gatesnotes.com/meet-bill/source-code/reader/microsoft-original-source-code) and it has a great opening piece...