is there any sp_ ???? database that can give me the collate of my database?

Posted on 2007-11-14
Last Modified: 2012-08-14
Hello guys,

I need to get the collate of my database, how to do that?

Is there any sp_collate that can return all collate in SQL?

Question by:hidrau
  • 3
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 20281879
fn_helpcollations ()
LVL 75

Accepted Solution

Aneesh Retnakaran earned 500 total points
ID: 20281884
SELECT * FROM ::fn_helpcollations ()
LVL 31

Expert Comment

by:James Murrell
ID: 20281921
Take a look at

good explanation and syntax

Author Comment

ID: 20282136
ok, and How can i get the colate of my database?
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 500 total points
ID: 20282280
sp_HelpDB 'urDBName'  

and check for the status column

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now