SQL Server Performance Forum – Threads Archive

Show SQL Collation

Hi there Probably an easy question but how can I check to see how a particular instance of SQL Server is setup collation wise. is there a SP that you can run to show this? I need to know what collation a particular instance is as I am going to move a database to a new server and want to ensure the collation is the same. Thanks
Ronnie
Yesterday it worked…Today it doesn’t – That’s Microsoft

---

sp_helpsort — Rediscover the web
http://www.mozilla.org/firefox/

---

I think sp_helpserver will give you the details

---

SERVERPROPERTY ( Collation) Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

I think it should be SERVERPROPERTY(‘collation’). — Rediscover the web
http://www.mozilla.org/firefox/

---

One should remember that it works only with linked and remote servers. — Rediscover the web
http://www.mozilla.org/firefox/

---

yes that is the better method
You can run select serverproperty(‘Collation’) to get the server collation
and select databasepropertyex(‘dbname’,’Collation’) to get the database
collation

---

Play with this scriptlet select
serverproperty(‘collation’)[Server collation]
,name [Database Name]
,databasepropertyex(name,’collation’) [Database collation]
from master.dbo.sysdatabases (nolock) Also, have a look onhttp://skchandra.blogspot.com/2005/06/useful-functions-related-with.html
/* SKChandra */

---

Thanks for the correction Chopeen, sometimes a bit of missing information leads to major malfunction. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>