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)

2007-04-26 (first published: )

458 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

Right place for newly graduates?

By LeviHampton

Hi everyone, I have a brother who just graduated with a programming major. And...

SSRS Report Parameters Interactive

By Morissette

Hi, I have a table that has a dept_id, sect_id, div_id, item_id, and description. ...

Please recommend me some documents about SQL ?

By LloydRice

I am working with a new field, which is SQL, do you know about...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers