> When generating a sql script I see "COLLATE Latin1_General_CI"... is this
> the database default?
as long as not differetly specified at the column creation time, char,
varchar, nchar, and so on, columns inherit the database collation specified
at database creation time.
> Is it good to use this?
I'm sorry, please excuse my poor english....this depends on what you mean by
if you are asking if this type of collaction is right, this depend on your
needs about sort order and specific collation rules....
if you are asking if it is corect to directly specify the collation rules in
the sql script, then yes, it is correct to do il, as it is correct specify
WHERE [column] COLLATE Latin1_General_CS_AI = 'piPPo'
in order to get a result where case are ginored like
hth and please excuse my poor english
DbaMgr2k ver 0.4.0 - DbaMgr ver 0.50.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
--------- remove DMO to reply