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

461 reads

Blogs

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

What is Always Encrypted and how does it work?

By

Always Encrypted was a new encryption feature added to SQL Server with the 2016...

Power BI – Empowering Users to Disable Tooltips

By

Let’s set the scene. You’ve built a wonderful, useful, and descriptive report for your...

Read the latest Blogs

Forums

Efficient Airport Transfer in Mauritius - Reach Your Destination with Ease!

By limofahr

Make your arrival in Mauritius hassle-free with our efficient airport transfer service. Our experienced...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers