Database Collation Is Null

Question

Post reply

Database Collation Is Null

Andy Warren

SSC Guru

Points: 119902
More actions
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 17, 2014 at 1:25 am

This was removed by the editor as SPAM

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

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Nice way to end the week, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

free_mascot One Orange Chip Points: 27164 More actions · Answer 2

Nice one.

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

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 3

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

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 4

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

Stuart Davies SSCoach Points: 19505 More actions · Answer 5

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

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 6

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!

Umer Akram SSC-Insane Points: 22209 More actions · Answer 7

Umer Akram

SSC-Insane

Points: 22209

January 17, 2014 at 3:49 am

#1681009

nice question .... thanks for sharing

Ed Wagner SSC Guru Points: 287026 More actions · Answer 8

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

Andy Warren SSC Guru Points: 119902 More actions · Answer 9

Interesting about the inconsistent results.

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

Nevyn SSChampion Points: 14210 More actions · Answer 10

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.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

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

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 12

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

ssimmons 2102 SSCommitted Points: 1634 More actions · Answer 13

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

Database Collation Is Null

Cookies on SQLServerCentral