Really odd. Both databases has auto_close set to OFF.

I use this query to return the values, but two databases has no rows. The other databases has rows:

SELECT cntr_value

FROM ...

It works George. Thank you very much !!

GilaMonster (10/11/2013)

---

Try an outer join, or join to exec_sessions instead. Session space usage is for all current sessions, regardless of whether or not they are currently running queries. exec requests...

Igor,

I ran the command and right now there's none opened transactions.

Hi Jeff,

I'm not sure If I understood your question, but I running the command DBCC SHRINKFILE('name').