Monthly Archives: November 2008

How to change a column collation to the default database collation

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 … Continue reading

Posted in SQL Server | Tagged , , | 1 Comment

Unauthorized error when using Integrated Security

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. … Continue reading

Posted in IIS | Tagged , , , | Leave a comment