April 27, 2009 at 6:02 am
Hi all, there is anyway to find wich filenum, pagenum from certain information. Something like i have a table with id, name and adress. I want to know filenum and pagenum , to use in dbcc page, which corresponds a name 'Luis Roberto'... How can i find this ?
Thanks a lot
April 27, 2009 at 6:22 am
There's no easy way to find which page has a certain row on it. You can look with DBCC IND to see all pages allocated to a table, or in some of the system tables to see what is the root page and first page of the clustered index - from there you can navigate along the leaf-level to find the page you want. For an example script, see this blog post.
Let me know if you have any more questions (I wrote DBCC PAGE for SQL 2005).
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
April 27, 2009 at 6:27 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply