title: Alter stored procedure or function added extra blank line gap
body: <p>In SQL Server 2012 when I write code for stored procedure and for any function. After that when I want to alter it added extra blank line gap, that's why it seem very unacceptable lenghty..</p>
  
  <pre><code>CREATE proc sp_delete_Rte_article_admin_Latest   
  (    
  @id int    
  )    
  as    
  begin    
  if exists (select * from tblRte where Id=@id )    
  begin    
      declare @IvanID bigint  
  
      set @IvanID=(select [IvanArtId] from tblRte where Id=@id )  
      insert into tblRteOnDelete([IvanArtId],[StoryType],[ChannelType],[Filename],
                  [Headline],[PublishDate],[Title],[DocScope],[KeyWord],[Byline],[City],
                  [State],[StoryDate],[BodyContents],[DownloadedDate],DeleteDate)
      select [IvanArtId],[StoryType],[ChannelType],[Filename],[Headline],[PublishDate],
             [Title],[DocScope],[KeyWord],[Byline],[City],[State],[StoryDate],
             [BodyContents],[DownloadedDate],GETDATE()
        from tblIvanhoeXmlFeeds
       where Id=@id   
  
      delete from tblRte where Id=@id   
      delete from tblUpdatedRteTopics where IvanArtId=@IvanID  
      delete from tblCheckAllowRte where ArticleID=@IvanID  
      delete from tblAddRteeApprove where ArticleID=@IvanID  
  
      return 1    
  end    
  else    
  begin    
      return 0    
  end    
  end
  </code></pre>
  
  <p>What should do for moving this for all time..any setting ?</p>