Technical Article

Find the database by table name

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: )

486 reads

Blogs

Webinar: Navigating the Database Landscape in 2026

By

For a number of years, we’ve produced the State of the Database Landscape report,...

Claude AI Convinced Me Not to Build an iPad App

By

I coach volleyball and I do a lot of stat stuff on paper. I...

A New Word: Dolorblindness

By

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

Read the latest Blogs

Forums

The Power of Data and Privacy

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Power of Data and...

What's the Date?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item What's the Date?

Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform

By John Miner

Comments posted to this topic are about the item Two New Shortcuts for Fabric...

Visit the forum

Question of the Day

What's the Date?

In SQL Server 2025, there is a new function that returns the current date without the time. What is it?

See possible answers