I am updating tables via Management studio using the design view.
When I attempt to make changes to a FK and an error occurs e.g. I try to set the cascade Delete rule to Set NULL I then save the changes and receive an error saying this is not valid due to multiple cascade paths.
What I expect to happen is for the changes to be rolled back but instead when I look in my constraints the FK that I was trying to update has been deleted, and I have to recreate them.
Is there a way to setup Management studio so it rollback these changes when an error occurs?