How to change SSMS warning settings on SQL without any queries?

Question

I believe there is a SSMS setting somewhere in the options menu to allow changes to tables that require dropping and recreating. How do i do it? I hope I'm being clear with my question.

score 2 · Accepted Answer · answered Aug 23 '13 at 14:31

2

I'm using the 2008 R2 tools but I believe it's in the same place.

Tools - Options - Designers - Table and Database Designers - Prevent saving changes that require table re-creation.

enter image description here

answered Aug 23 '13 at 14:31

Kenneth Fisher

3,692
19
21

I'm released! Thanks a lot, this is what I need. Yes, it's the same way for SQL Server 2012 – A_Pointar Aug 23 '13 at 14:33

How to change SSMS warning settings on SQL without any queries?

1 Answers1