BUG: Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE
jamal
Posts: 47 Bronze 3
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:
James
Comments
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.