How can we help you today? How can we help you today?

BUG: Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE

I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement. I did the same compare using SQL Compare 12.2.1.4077 and the difference was not flagged. Is there an option to stop this from being flagged in SQL Compare 13? Here's a screenshot of the v13 difference: 4z1ekdh1xlc7png
jamal
0

Comments

2 comments

Sort by
  • jamal
    And the resulting deploy script does this:
    PRINT N'Altering permissions on [dbo].[GetWebinarEmailsAsFetchXmlValues]'
    GO
    GRANT EXEC ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]
    GO
    REVOKE EXECUTE ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]

    which actually revokes the permission it just gave resulting in a real difference and creates a never ending loop of differences if you continue to run the deploy scripts one after the other.
    jamal
    0
  • jamal
    (removed)
    jamal
    0

Add comment

Please sign in to leave a comment.