Prev: pack service SP3
Next: Scripting Tables in 2008 SSMS
From: big on 4 Jun 2010 09:29
Hi,
in 2005 MS SQL , how can I see coallating designator and sort order of my
instance ?
Thanks.
From: Erland Sommarskog on 4 Jun 2010 09:48
big (big(a)discussions.microsoft.com) writes:
> in 2005 MS SQL , how can I see coallating designator and sort order of my
> instance ?

SELECT serverproperty('Collation')

Note that the collation can be over-ridden on database level and eventually
on column level.


--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
 | 
Pages: 1
Prev: pack service SP3
Next: Scripting Tables in 2008 SSMS