raulggonzalez (1/17/2014)

---

Stuart Davies (1/17/2014)

---

raulggonzalez (1/17/2014)

---

Thanks for the question, but I have to disagree with one of the answers.

I have a number of offline databases in one of my servers and the following query returns values for all of them

select name, state_desc, DATABASEPROPERTYEX(name, 'Collation')

from sys.databases

where state_desc = 'OFFLINE'

I can see that BOL states opposite, but if anybody else want to try and share the result, would be great

Most odd - I have the same symptoms one one of my (2005) servers. 6 databases are off line - yet I get a collation for them.

Any ideas why?

Mine is a 2008R2 Standard SP2 ...

Wow!! I just tried on another 2008R2 Enterprise SP2 and it does return NULL ...

And SQL Server 2012 Standard Edition SP1 returns NULL...

This is pretty weird!