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

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?

Thanks
LVL 1
hidrauAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
SELECT * FROM ::fn_helpcollations ()
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
fn_helpcollations ()
0
 
James MurrellProduct SpecialistCommented:
Take a look at

http://msdn2.microsoft.com/en-us/library/ms187963.aspx

good explanation and syntax
0
 
hidrauAuthor Commented:
ok, and How can i get the colate of my database?
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
sp_HelpDB 'urDBName'  

and check for the status column
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.