Made changes to DB Schema by adding Status ID in Account table and other changes

Changes to DB schema - adding status id in Account table and other
changes
Remove Not For Replication for SQL Azure and use WITH NOLOCK

In Sql Azure, WITH NOLOCK works and NOT for replication does not work.
Made changes in schema and one of the stored procedures.
Adding WITH NOLOCK feature for SELECT, INSERT and UPDATE SP

Adding with NOLOCK feature for SQL Azure