Options

Trigger can not be decrypted

swadeswade Posts: 3 New member
in SQL Compare
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?
Tagged:
· Share on Twitter

Best Answer

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Answer ✓
    @swade

    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?
    · Share on Twitter

Answers

  • 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.
    · Share on Twitter
  • Options
    sam.blackburnsam.blackburn Posts: 224 Gold 2
    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
    · Share on Twitter
Sign In or Register to comment.