title: Remove [NOT FOR REPLICATION] from all Identity columns of Database tables
body: <p>I have a Database which is containing lot of tables with Identity columns set to [NOT FOR REPLICATION]. in SQL Server 2008 R2
  Is there any way that I can remove this constraint from all tables from Management Studio or any Query thanks.</p>
  
  <pre><code>Create Table mytbl (
  [EmpId] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
  </code></pre>
  
  <p>I tried this but it is removing one by one.</p>
  
  <pre><code>ALTER TABLE dbo.tblAttendance ALTER COLUMN Id
           DROP NOT FOR REPLICATION;
  </code></pre>