Zvi Ginsberg,
Assuming its SQL2000....
To view:
--server level
sp_helpsort or
SELECT CONVERT(char(60), SERVERPROPERTY('collation'))
--database level
sp_helpdb <databasename>
--tablelevel(for each columns indiv.)
sp_help <tablename>
To change:
--server level
rebuild master database
--database level
ALTER DATABASE databasename COLLATE....
--table level
ALTER TABLE tablename ALTER COLUMN columnname COLLATE...
Dinesh.
Quote:
> Is there a way to view and change the collation method on a databasde in
SQL
> Server?
Collation Type