Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Database Collation Is Null Expand / Collapse
Author
Message
Posted Thursday, January 16, 2014 8:16 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Today @ 12:51 PM
Points: 6,808, Visits: 1,938
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
Post #1531902
Posted Thursday, January 16, 2014 8:16 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 12:30 AM
Points: 1,804, Visits: 783
Nice way to end the week, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective





Post #1531903
Posted Thursday, January 16, 2014 11:17 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Nice one.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1531929
Posted Thursday, January 16, 2014 11:49 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:28 AM
Points: 13,641, Visits: 11,517
Easy one to end the week, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1531932
Posted Friday, January 17, 2014 1:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
Good question, thanks.
Nice one to wind down the week on.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1531950
Posted Friday, January 17, 2014 2:20 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 674, Visits: 976
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
Post #1531962
Posted Friday, January 17, 2014 3:26 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 10:38 AM
Points: 3,350, Visits: 3,651
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
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
Post #1531980
Posted Friday, January 17, 2014 3:37 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 5:21 AM
Points: 674, Visits: 976
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!
Post #1531984
Posted Friday, January 17, 2014 3:49 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, December 19, 2014 3:33 AM
Points: 856, Visits: 1,506
nice question .... thanks for sharing
Post #1531987
Posted Friday, January 17, 2014 5:46 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:35 PM
Points: 4,618, Visits: 4,076
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
Post #1532012
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse