Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE

jamal

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:



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.

(I am reposting this https://forum.red-gate.com/discussion/83038/sql-compare-13-flags-grant-exec-as-different-than-grant-execute/p1?new=1 in a more appropriate place)

AshaPatel

Hi jamal,

Thanks for your post! This is a bug that has been fixed in version 13.2.4.5728 of SQL Compare.

This version is currently only available as a Frequent Update release. You can download it by going to "Help" > "Configure frequent updates" and selecting the check box, then going to "Help" > "Check for updates".

Alternatively, if you don't want to enable frequent updates this version will be released to default within the next two weeks.

Please let us know if you continue to see any problems!

Thanks,
Asha