SQL Management Studio 2008: changes to table which require recreation of the table fail.

Posted on by

If you ever make a big change to a table, which would require the SQL Management Studio 2008 to drop and recreate the table you might get this error:

This can be prevented by switching the following checkbox off: Tools > Options:

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>