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

494 reads

Blogs

Who Are You Doing It For?

By

But as I've matured over the years, I came to realize that I needed...

Presenting Twice in May 2026

By

I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...

Finding the Next Sequence Value: #SQLNewBlogger

By

I saw a question asking about the next sequence value and decided to try...

Read the latest Blogs

Forums

A Fun Computer Quote

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Fun Computer Quote

AI Database Central

By Steve Jones - SSC Editor

Comments posted to this topic are about the item AI Database Central

The Grafana Alternative to SSRS and Power BI

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Grafana Alternative to SSRS...

Visit the forum

Question of the Day

A Fun Computer Quote

Which movie featured this quote?

"All programs have a desire to be useful."
Happy April Fools!

See possible answers