GTTools.com

If you for some reason needs to change the collation of a column in SQL Server to the default database collation, you can use the following syntax:
ALTER TABLE <table_name> ALTER COLUMN <column_name> <current_data_type> COLLATE database_default
Eg.:
ALTER TABLE myTable ALTER COLUMN myColumn TEXT COLLATE database_default

Sometimes when I’m setting up a new server and creating a site using only integrated security I am unable to access the site.
Instead of direct access to the site, a dialog pops up asking for user name and password. Even if I enter a valid domain user and the correct password no access is given [...]