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 […]

2 (1)

You rated this post out of 5. Change rating

2007-04-26 (first published: )

462 reads

Blogs

Becoming Kristyna Ferris <3

By

Hey folks, fun personal post today. A few weeks ago, I got married! My...

What I Love About My Job

By

In June this year I took redundancy from the company I’d worked at for...

TryHackMe Advent of Cyber

By

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure...

Read the latest Blogs

Forums

Backing Up Master

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing Up Master

Window Function Basics - PARTITION BY

By Emmitt Albright

Comments posted to this topic are about the item Window Function Basics - PARTITION...

Focus on Growth in Your Career

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Focus on Growth in Your...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers