Browse by Tags

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 08:10 AM | ssqa.net | 1 comment(s)

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...

Filed under: sql server, database, tsql, table, change, indexes, setup, collation, installation, constraint, bcp