Why i get dbid 32767

Question

Why i get dbid 32767

Atif

Hall of Fame

Points: 3578
More actions
January 1, 2009 at 4:22 am

#126234

Running the following script why i get dbid 32767 for all generated rows
SELECT top 10 bucketid, objtype, dbid, text
FROM sys.dm_exec_cached_plans
CROSS APPLY sys.dm_exec_sql_text(plan_handle)
GO
Regards
DBDigger Microsoft Data Platform Consultancy.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What are the queries associated?

DBID 32757 is the resource database, where all the system views, functions and procedures are stored. So if the queries that you see are system procs, you'd expect the dbid to be 32767.

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Atif Hall of Fame Points: 3578 More actions · Answer 2

I am trying to get cache objects as we get through syscacheobjects in SS2000. There we have dbid for databases to which the cache object belongs.

DBDigger Microsoft Data Platform Consultancy.

Atif Hall of Fame Points: 3578 More actions · Answer 3

thanks for the help, the reason to get me confuse was that function db_name(dbid) was not providing me name of any db. So now i have got it.

DBDigger Microsoft Data Platform Consultancy.