Since I have now run into this issue 3 times and each time had to look it up to find out to fix it, I decided to post about it. If you use SSMS 2008/2008 R2 you will find out very quickly that altering a table using the GUI will throw an error. This is because SQL has added a new “feature” to prevent us from doing this.
In order to turn this “feature” off you will need to go to tools > options. On this screen uncheck this option:
I do not think this is a bad “feature”, but it should be something that admins can set at the server level to prevent it in UAT/Production environments… makes little sense in a development environment.
0 comments:
Post a Comment