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.

You rated this post out of 5. Change rating

2014-10-22

9,484 reads

Blogs

TRY_PARSE Limitations: #SQLNewBlogger

By

I got a notification from a question I’d posted at SQL Server Central: Getting...

SQL Server sa Account Security: Rename, Disable & Best Practices

By

SQL Server sa Account Security: Rename, Disable & Best Practices In...

Stanford Emerging Technology Review 2026 Report is out

By

Artificial Intelligence and quantum computing are two areas of emerging technology that receive most...

Read the latest Blogs

Forums

Alamat Kantor BCA KCU Green Garden Tlp:08217555651

By layanan_Bca88

Hub Via Wa:628217555651 Alamat: Blok A.7 No, Komplek, Jl. Perumahan Green Garden 31-35, RT.1/RW.3,...

Alamat Kantor BCA KCU Sunter Telp:08217555651

By R4nt4u

Hub Via Wa:628217555651 Alamat: Jl. Danau Sunter Utara Jalan Kavling No.3 Blok A, RT.2/RW.18,...

Are You Working More Hours?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Are You Working More Hours?

Visit the forum

Question of the Day

A Limited Startup

I add this parameter to SQL Server 2025 in the Configuration Manager:

-mDynamics
What does this do?

See possible answers