All authors

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

459 reads

All authors

Blogs

Enabling an Index: #SQLNewBlogger

By

I don’t do a lot of work with disabled index, but I learned how...

Back to Boston for SQL Saturday

By

I’m leaving again tomorrow for a trip. This time I head back to Boston...

T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?

By

Most of us who work with data have, at least a few times, been...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers