i was using SQL Server management studio 2008 diagram editor which i was using after years of using sql server managemenr studio 2005 whcih i think is the easiest tool for modeling Database.
and i came across this message
turns out there’s an option that i have to uncheck for this to work
tools ==> options and then find this option
