• So i need to change all my SP's and Views to avoid nolock hint.

    so in this snapshot isolation level no locking happens at all for reporting scripts ( for read only scripts ) how about SP's which runs under transaction.