Thanks for article Roy.

i am considering turning on these features on an application we have at my current company, but had a question.

If i alter my database with;

ALTER DATABASE MyDatabase

SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE MyDatabase

SET READ_COMMITTED_SNAPSHOT ON

Do I need to alter all my existing stored procedures that make use of the

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

statement?

also, the hint with (NOLOCK), should those also be removed?

Thanks.