Wednesday, March 21, 2012

dbcc page

Hi,
How can i check witch object in my database is associated with this page
number?
PAG: 7:1:3794813
Outup of DBCC TRACEON (1204,3605,-1)
Im' having a lot of deadlock problems, any good links ?
Thanks in advance
Celso CorreiaThe output of DBCC PAGE includes a row with
Metadata: ObjectId = number
Use this number as an argument to the OBJECT_NAME function:
SELECT OBJECT_NAME(number)
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"CC" <CC@.discussions.microsoft.com> wrote in message
news:D338F279-6871-4657-BB76-FCAFEFF37DF4@.microsoft.com...
> Hi,
> How can i check witch object in my database is associated with this page
> number?
> PAG: 7:1:3794813
> Outup of DBCC TRACEON (1204,3605,-1)
> Im' having a lot of deadlock problems, any good links ?
> Thanks in advance
> Celso Correiasql

No comments:

Post a Comment