There is a myth (rather a wrong impression) in database world that SQL Server setup is pretty easy, what you do is insert setup-media into drive and click next....next.....next, well it is not!!! .... read here ...
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...
