Activity overview
Latest activity by davesbrown
Had a resurfaced issue - https://forum.red-gate.com/discussion/88871/dropping-schemabinding
Tried 'Ignore Bindings' and the script generates
) RETURNS Table WITH RETURN ( SELECT
We have to hand edit the script to change WITH to 'AS'
/ comments
Had a resurfaced issue - https://forum.red-gate.com/discussion/88871/dropping-schemabinding
Tried 'Ignore Bindings' and the script generates
)RETURNS TableWITH RETURN( SELECT
We have to hand e...
He @Pete_Ruiz Thanks for the reply. I think we solved the issue with some overlooked filters and checking deploy with dependencies; we had some dependent views. Thanks, Dave / comments
He @Pete_Ruiz Thanks for the reply. I think we solved the issue with some overlooked filters and checking deploy with dependencies; we had some dependent views.Thanks,Dave
Dropping Schemabinding?
We have some functions that are defined "With Schemabinding" and when deploying including dependencies, RG Compare creates scripts such asPRINT N'Removing schema binding from ......ALTER FUNCTION ....
"Unfortunately, this is currently the way SQL Compare works..." It's not how it always worked, it has been a very recent change and has affected my automatic deployments. I have made the change on my end though. / comments
"Unfortunately, this is currently the way SQL Compare works..."It's not how it always worked, it has been a very recent change and has affected my automatic deployments. I have made the change on ...
No fix yet for import crash? Updated to version 1.5.0.1355 / comments
No fix yet for import crash? Updated to version 1.5.0.1355
The Tools Export Import editing method is no longer working with version 1.4.18.1337 - After importing and attempting to use the list in the dropdown causes the app to crash. Sent in the bug report / comments
The Tools Export Import editing method is no longer working with version 1.4.18.1337 - After importing and attempting to use the list in the dropdown causes the app to crash. Sent in the bug report
Ah yes, that upgrade has fixed my problem, thank you / comments
Ah yes, that upgrade has fixed my problem, thank you
SQL Compare freezes when no objects selected for deploy
Version 13.6.14.9174 ProfessionalNo indication of 'Not Responding' have to kill process through Task Manager