Geeks With Blogs
Robert Bernstein's Blog Adventures in Windows, .NET, and C++ SQL Microsoft SQL Server
Enable SQL Server Mgmt Studio to Overwrite Table Designs
By default, SQL Server Management Studio (SSMS) will not let you save changes to the designs of your tables. When you attempt to do so, it wants you to drop and re-create the table. You will typically see a dialog similar to the following: However, SSMS will actually let you perform such a change without have to drop the table and re-create it. To enable this feature, you need to select Tools / Options from the Menu. Then, navigate to Designers / Table and Database Designers and uncheck the option ......

Posted On Monday, September 27, 2010 11:18 AM

Copyright © Rob | Powered by: