Monday, June 23, 2008

Change Default Database Collation

We had a wrong database colletion in our MS SQL Server. Trying to change the collation caused problem like "The database could not be exclusively locked to perform the operation". Here is how we solved it.

alter database db_name set single_user
alter database db_name collate SQL_LATIN_GENERAL1_CI_AS
alter database db_name set multi_user

Over!

Tuesday, February 5, 2008

Blond Secrets

How to debug javascript in Visual Studio?
It's pretty simple. Just add keyword "debugger" in your javascript. Visual Studio treat it as breakpoint and entering in debug mode from this word.
Important things: debug project using "debug & run", not "attach to proccess", and don't forget to enable debugging in your IE.