Post reply

Database Collation Is Null

  • January 16, 2014 at 8:16 pm

    #302859

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

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • January 16, 2014 at 8:16 pm

    #1680943

    Nice way to end the week, thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • January 16, 2014 at 11:17 pm

    #1680962

    Nice one.

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

  • January 16, 2014 at 11:49 pm

    #1680965

    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

  • January 17, 2014 at 1:25 am

    This was removed by the editor as SPAM

  • January 17, 2014 at 2:20 am

    #1680988

    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

  • January 17, 2014 at 3:26 am

    #1681004

    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

  • January 17, 2014 at 3:37 am

    #1681008

    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!

  • January 17, 2014 at 3:49 am

    #1681009

    nice question .... thanks for sharing

  • January 17, 2014 at 5:46 am

    #1681029

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

    Tally Tables - Performance Personified
    String Splitting with True Performance
    Best practices on how to ask questions

  • January 17, 2014 at 6:32 am

    #1681041

    Interesting about the inconsistent results.

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

  • January 17, 2014 at 6:51 am

    #1681046

    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.

  • January 17, 2014 at 6:58 am

    #1681052

    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

  • January 17, 2014 at 7:11 am

    #1681058

    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

  • January 17, 2014 at 7:37 am

    #1681070

    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