Missing Option in SQL 2005 Tools

Hello: Although recall seeing the following option in SQL 2005 in the past, but unable to see it on an installation now. Any idea where this is hidden? Snapshots attached (the option is visible in SQL 2008R2 & 2014, but not SQL 2005).

Tools > Options > Designers > Table and Database Designers: Prevent saving changes that require table recreation?

Many thanks!
sql2005.jpg (61.1 kB)
sql2008.jpg (93.6 kB)
more ▼

asked Jul 25 at 02:40 PM in Default

Mansour Shoari gravatar image

Mansour Shoari
435 14 14 16

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
No this is not hidden. The option was introduced in SQL 2008
more ▼

answered Jul 29 at 06:58 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.9k 47 49 76

Thank you for confirming this.
Jul 29 at 12:47 PM Mansour Shoari
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 25 at 02:40 PM

Seen: 222 times

Last Updated: Jul 29 at 12:47 PM