So that is the problem: you are using the UI, instead of using T-SQL commands directly. At very least if you use the UI, and things don't work out, you should use the Script button to see what SSMS intend to do.