Here is the sytax to change the Collation for the database

ALTER DATABASE DBNAME COLLATE Latin1_General_CI_AS
GO

Naresh

-----Original Message-----
From: Shafeeq Ahamed [mailto:[Email Address Removed] Wednesday, December 31, 2003 3:10 PM
To: LazyDBA.com Discussion
Subject: RE: collation name


hi manoj,
thanks for the answer, it worked to find the database collation name
and how to change the collation name ?
thanks
shafeeq


>From: Manoj Thomas <[Email Address Removed] Shafeeq Ahamed <[Email Address Removed] "LazyDBA.com Discussion"
><[Email Address Removed] RE: collation name
>Date: Wed, 31 Dec 2003 14:46:19 +0530
>MIME-Version: 1.0
>Received: from mailserver01.satyam.net.in ([202.144.95.155]) by
>mc5-f21.hotmail.com with Microsoft SMTPSVC(5.0.2195.6713); Wed, 31 Dec 2003
>01:30:35 -0800
>Received: by MAILSERVER01 with Internet Mail Service (5.5.2448.0)id
><ZM5DQAR3>; Wed, 31 Dec 2003 14:46:20 +0530
>X-Message-Info: JGTYoYF78jFAQnv8NZEhJ3JZN0gLhArM
>Message-ID: <[Email Address Removed] Internet Mail Service (5.5.2448.0)
>Return-Path: [Email Address Removed] 31 Dec 2003 09:30:36.0561 (UTC)
>FILETIME=[BF1CE010:01C3CF80]
>
>
>
>
>
>select DATABASEPROPERTYEX('<dbaname>','collation')
>
>will give you collation name.
>
>
>manoj
>
>
>
>
>-----Original Message-----
>From: Shafeeq Ahamed [mailto:[Email Address Removed] Wednesday, December 31, 2003 2:48 PM
>To: LazyDBA.com Discussion
>Subject: collation name
>
>
>Dear Gurus,
>
>1. How can i check the database collation name if it is not present in the
>right click properties of database.
>
>2. How to change collation name to another collation name for a database ?
>
>thanks in advance
>shafeeq
>
>_________________________________________________________________
>Get a job today. http://go.msnserver.com/IN/39622.asp Post your CV on
>naukri.com today.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>Get today's cartoon: http://www.LazyDBA.com
>To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] drafts to 700 locations.
http://server1.msn.co.in/msnleads/suvidha/dec03.asp?type=hottag Click here.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page