Table Name

Technical Article

Finding a table name from a page ID

  • Article

Imagine you come to work in the morning and notice that some new rows have been entered into the msdb.dbo.suspect_pages table during the night. Usually the first thing you’re going to do is run DBCC CHECKDB, but if your database is a few TB, that could be several hours before you know where the problem is, and which table may have lost data. You want to find out which table is involved as soon as possible so you can explore your disaster recovery options.

2014-10-22

9,484 reads

Blogs

KDA: Echoes of Deception - Case 7

By

A fugitive cyber-criminal, a wingsuit, and 24 million flight records. Somewhere between Doha and...

Do This Before You Contact Your SQL Server Consultant

By

Say you need outside help. You’ve exhausted all the things that you could do...

Microsoft MVP 2026: Ten Years on the Data Platform

By

I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...

Read the latest Blogs

Forums

Do we have a forum for SQL Server 2025?

By sqlfriend

Not seeing a 2025 forum, it looks to me the site will not going...

Developer edition cannot be connected from other computers

By sqlfriend

I installed a new SQL server 2025 Enterprise developer edition for our development environment....

How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning

By Dinesh Asanka

Comments posted to this topic are about the item How Clustering can be Used...

Visit the forum

Question of the Day

Moving the Error Log

How can I change the location in which the SQL Server error log is written in SQL Server 2025?

See possible answers