June 21, 2012 at 7:05 am
I wanted to know if anyone knew what this system table is for. It showed up in one of my traces but when I try to query it I get a message that no such object exists. I assume it is some system table but I'm not sure why I cannot locate & query it. Thoughts?
June 21, 2012 at 7:55 am
What table?
Jared
CE - Microsoft
June 21, 2012 at 8:14 am
Sorry, I see you have it in the subject but not in the body of your post. Seems that it always shows up in a DBCC CHECKDB when I google it, but I cannot find any explicit reference to its location or purpose.
Jared
CE - Microsoft
June 21, 2012 at 8:22 am
after looking into this a little more, my guess is that this is in the Resource database and cannot be accessed. Best not to worry about it.
Jared
CE - Microsoft
July 3, 2012 at 11:47 am
hey I appreciate the replies. I think it is related to IntelliSense within SSMS. I tracked down where the times i was seeing it people were using SSMS & running queries. I have also seen it in DBCC results so maybe it is just some internal working area. I agree with your assessment that is probably best to leave it be.
July 3, 2012 at 11:53 am
None of the system tables can be directly queried in SQL 2005 and above. Unless there's some reason to be concerned, just ignore it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply