Hi,
In SQL Compare 6 there is a bug in the remove schema binding logic if a function (or a view) has schema binding defined and a comment exists on the same line as the WITH SCHEMABINDIND clause.
e.g.
CREATE FUNCTION fn_Test (...
...
WITH SCHEMABINDING -- This comment will result in incorrect syntax.
AS
...
If SQL Compare decides it needs to drop the schema binding in it's synchronisation process then the SQL code it generates is incorrect. The ALTER FUNCTION statement leaves the WITH term in the definition which results in a syntax error.
e.g.
PRINT 'Dropping Schema Binding on function fn_Test'
...
ALTER FUNCTION fn_Test (...
...
WITH -- This comment will result in incorrect syntax.
AS
...
Thanks
Alex
In SQL Compare 6 there is a bug in the remove schema binding logic if a function (or a view) has schema binding defined and a comment exists on the same line as the WITH SCHEMABINDIND clause.
e.g.
If SQL Compare decides it needs to drop the schema binding in it's synchronisation process then the SQL code it generates is incorrect. The ALTER FUNCTION statement leaves the WITH term in the definition which results in a syntax error.
e.g.
Thanks
Alex