Options

Anyway to ignore code comments?

bmasseybmassey Posts: 2
edited September 26, 2007 4:26AM in SQL Compare Previous Versions
We have a script that will auto generate history triggers. At the top of the trigger comments are added. For example:

/************************************************************************************************************
Created By: ADMIN\F_LastName
Created On: 04/29/2007
Comments: Auto generated trigger
***********************************************************************************************/

The "Created By:" comment is always tagged with the logged in users account (SUSER_SNAME()). However, the account is usually created by a different user in each of our environments (dev, qa and prod). As a result, all of these triggers are coming back as discrepancies, due to the difference in the "Created By" comment.

Comments

  • Options
    Hi,

    There is an option in the project configuration to ignore comments in views, stored procedures, and UDFs. Note that the comments will still be synchronized if other differences are found, though!
Sign In or Register to comment.