I use SQL server 2008 and I have created some tables. I want to edit some of them, but SSMS does not let me and will receive error!
How can I solve my problem?
Asked
Active
Viewed 103 times
0
Jason Evans
- 28,906
- 14
- 90
- 154
Johanna
- 27,036
- 42
- 89
- 117
-
1can you post the error message that you get? – Raj More Jun 09 '10 at 19:17
-
1Possible duplicate of [Saving changes after table edit in SQL Server Management Studio](http://stackoverflow.com/questions/1969096/saving-changes-after-table-edit-in-sql-server-management-studio) – Bogdan Bogdanov Jan 15 '16 at 14:40
1 Answers
2
Inside SSMS go to menu:
tool -> options -> designers
Uncheck prevent saving changes that require table re-creation
Image:
Manube
- 5,110
- 3
- 35
- 59
nathan gonzalez
- 11,817
- 4
- 41
- 57
-
1I can't believe you connected that question to that response... If that really is the problem you sir are a genius. Or you've seen this issue before :) – Mike M. Jun 09 '10 at 19:20
-
-
He seen that problem before @Mike M. :). I have similar issue. – Bogdan Bogdanov Jan 15 '16 at 14:35