case sensitive sql server

in sql server 2000 or 2003 how can i tell if a database is case sensitive or not??select case when 'a' = 'A' then 'not case sensitive' else 'case sensitive' end|||in sql server 2000 or 2003 how can i tell if a database is case sensitive or not??

sql server 2003?
well, for your question,check this ...
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm