SQL SERVER 2012 table modify

Question

I am using VB2012 and SQL Server 2012. I exported a table from Access Database (2000 Format) to SQL Server 2012. But SQL Server is not allowing me to modify the table. I get a message that the table needs to be dropped and recreated. Is there a way to solve this.

score 0 · Answer 1 · answered Oct 08 '13 at 16:52

0

Assuming you have the right permissions, you need to go to "Tools->Designers->Table and Database Designers" and uncheck the "Prevent saving changes that require table re-creation" option.

answered Oct 08 '13 at 16:52

Lamak

69,480
12
108
116

Tanx for your answer. – Raynish Oct 08 '13 at 17:04

SQL SERVER 2012 table modify

1 Answers1