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]MS Sql Server LazyDBA home page