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.
/************************************************************************************************************
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.