Database Collation Is Null

  • Comments posted to this topic are about the item Database Collation Is Null

  • Nice way to end the week, thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Nice one.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Easy one to end the week, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • This was removed by the editor as SPAM

  • 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

  • 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?

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
    I would never join a club that would allow me as a member - Groucho Marx

  • 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!

  • nice question .... thanks for sharing

  • Thanks for a simple question to end the week and have a good weekend.

  • Interesting about the inconsistent results.

  • A bit too guessable. If it was going to be select 3, there should have been a few more options. Otherwise its 'one of these things is not like the other', which was easy with the options provided.

  • 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

    I took my test bed offline and got this result on SQLServer2008 (Version 655)

    name state_desc (No column name)

    TWA_Practice OFFLINE NULL

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thomas Abraham (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

    I took my test bed offline and got this result on SQLServer2008 (Version 655)

    name state_desc (No column name)

    TWA_Practice OFFLINE NULL

    So did I on SQL Server 2008R2 Enterprise and SQL Server 2012 Standard (NULL), but not in 2008R2 Standard (actual value)...

    thanks for your feedback

  • How about if you don't have permissions? doesn't that return a NULL?

Viewing 15 posts - 1 through 15 (of 32 total)

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