Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

table,bcp,constraint,database - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » table » bcp » constraint » database (RSS)

TSQL to change collation of database, whats new in SQL 2008 then?

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...