December 3, 2009 at 8:11 am
Hi,
Is it possible to identify the number of rows (or size) of a temporary table created in other sessions? (I think its against the basics of temp tables but still wanted to check if there is any other way out?)
---------------------------------------------------------------------------------
December 3, 2009 at 8:16 am
Nope. sp_spaceused won't work for that. I don't think you can really access that for temp tables. Could be wrong, but they're really designed to be accessed only by the session that created them.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
December 3, 2009 at 8:19 am
Yes that makes sense,thanks GSquared 🙂
---------------------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply