How to set transaction isolation level as read uncommitted as default for users

Is it possible to set the transaction isolation level to read uncommitted for users by default in MS SQL Server Management Studio 2012?

I was thinking it could either be done through editing a config file or changing a reg key but i haven’t been able to locate anything that would change this yet.

Answer

As far as I know you can’t change the default lock level.

For workloads with a lot of reads and fewer writes, you can avoid blocking queries with multiversion concurrency control. That’s the default for Postgres and Oracle. In SQL Server, MVCC is called “read committed snapshot”, and you can enable it with:

ALTER DATABASE YourDb SET READ_COMMITTED_SNAPSHOT ON;