Comments are formatted wrong

• 
  Hi Torsten,
  
  Thanks for you post - We've been able to reproduce it and think we have a fix in the latest beta build (7.3.0.450). Please give it a try and let us know if it works as you'd expect.
  
  Thanks!
  Aaron.

  Aaron L August 23, 2016 11:32

  - 0 +
• 
  Fixed - thanks but I guess the behavior is still worng:
  

  /*******************************************************************************
  
  	troubleshooting queries
  
  ********************************************************************************/
  
  /*******************************************************************************
  
  	troubleshooting queries - sys.dm_exec_requests
  
  ********************************************************************************/
  
  /*
  	
  	sys.dm_exec_requests
  	Returns information about each request that is executing within SQL Server
  
  */
  
  SELECT *
  FROM sys.dm_exec_requests;
  GO
  SELECT 1;
  

  
  
  I would like to preserve the lines between the comments but would like to apply the formatting rules on the statement.
  
  This is the outcome:
  

  /*******************************************************************************
  
  	troubleshooting queries
  
  ********************************************************************************/
  --no line anymore - wrong
  /*******************************************************************************
  
  	troubleshooting queries - sys.dm_exec_requests
  
  ********************************************************************************/
  --no line anymore - wrong
  /*
  	
  	sys.dm_exec_requests
  	Returns information about each request that is executing within SQL Server
  
  */
  --no line anymore - wrong
  SELECT *
  FROM sys.dm_exec_requests;
  GO
  --new line correct
  SELECT 1;
  

  
  
  Thanks for your support!

  torsten.strauss August 24, 2016 03:24

  - 0 +
• 
  Hi Torsten,
  
  Just to clarify, are you saying that you have Preserve empty lines between statements turned off, but you'd like to still preserve empty lines between comments?
  
  Best regards,
  
  David

  David Priddle August 25, 2016 12:13

  - 0 +
• 
  Hi David,
  
  the lines between the comments were deleted which is wrong.
  Between the SQL statements the added line is correct.
  
  Seems that the formatting rules will be handled differently between comments and SQL code which is not my expectation....

  torsten.strauss August 25, 2016 13:40

  - 0 +
• 
  Hi Torsten,
  
  I've found what was causing this and improved the logic, so we'll include this in the next release. Hopefully this will solve your problem.
  
  Best regards,
  
  David

  David Priddle August 26, 2016 08:14

  - 0 +

Add comment

Please sign in to leave a comment.