This is a bug in the parsing engine Red Gate use. In SQL Prompt it just underlines the text red and displays an issue. But in Source Control it stop the changes being viewed thorugh Source control as i would imagine the same parsuing engine is used.
The following code parse's and executes fine in SQL but errors in source control.
1. Does anyone know if newer versions of Redgate have this fixed?
2. Does anyone know how to code around without putting the script in a string and executing the string?
ADD SIGNATURE TO OBJECT :: [Procedure]
BY CERTIFICATE [Certificate]
WITH password = 'Password';