check collation settings

Question

Post reply

check collation settings

sqlfriend

SSC Guru

Points: 52781
More actions
July 19, 2012 at 10:44 am

#259105

We have a small application that using sql express.
But I see no management studio installed on that server.
I would like to check what is setting for the SQL server collation and database collation, how can I do that?
Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

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

Sean Lange SSC Guru Points: 286590 More actions · Answer 1

A quick google search would be way faster for this type of thing. I typed "view collation sql server"...here is hit #1.

http://blog.sqlauthority.com/2007/08/30/sql-server-2005-find-database-collation-using-t-sql-and-ssms/[/url]

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

Lowell SSC Guru Points: 323518 More actions · Answer 2

just tested this, seems to give what you asked for:

select SERVERPROPERTY('Collation') As ServerCollation,

name As DatabaseName,

collation_name As DatabaseCollation

from master.sys.databases

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

timster Ten Centuries Points: 1033 More actions · Answer 3

Do you have SQL Management Studio Installed anywhere else try using that to connect to you express instance.

Or you can download Query Express its free

http://www.softpedia.com/get/Internet/Servers/Database-Utils/Query-Express.shtml

Then run this to get collation for your databases

SELECT name,

collation_name

FROM sys.databases

sqlfriend SSC Guru Points: 52781 More actions · Answer 4

Thanks, I know how to check collation from SSMS and code.

I cannot connect to this server somehow from other SSMS client.

And on the server itself no SSMS installed, there is only SQL server express installed.

How can I check that?

Sean Lange SSC Guru Points: 286590 More actions · Answer 5

sqlfriends (7/19/2012)
Thanks, I know how to check collation from SSMS and code.
I cannot connect to this server somehow from other SSMS client.
And on the server itself no SSMS installed, there is only SQL server express installed.
How can I check that?

Run a query. SSMS is not the only tool for executing a sql statement. 🙂 You may have to create a quick utility to run your query (web page, windows app, whatever)