What are the challenges you face when working across database platforms? Take the survey

Trigger can not be decrypted

swadeswade Posts: 3 New member
I am doing a SQL Compare like I have done many times before, but today I get the following warning when i try to deploy a table or a view: The trigger xxxxx cannot be decrypted in one or more of the datasources. its contents cannot be compared and it cannot be synchronized.   Why am I getting this warning and how can i resolve this?

Best Answer

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5

    If you want to compare and deploy encrypted objects then you need to be part of the sysadmin role and you need to have the View Server State permission.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?


  • Options
    swadeswade Posts: 3 New member
    I should add, I am comparing a snapshot to the database that was just refreshed from production. I made the snapshot, refreshed the database and am comparing the snapshot to the database.  The tables and views getting the warning have not been modified for 4+ years.
  • Options
    As Tianjao said, this is likely a permissions issue.  Please ensure SQL Compare is connecting to SQL Server with the same login as before, and check whether that user's permissions on the database have changed.
    Software Developer
    Redgate Software
Sign In or Register to comment.