Search This Blog & Web

Wednesday, August 11, 2010

Preventing table changes from SSMS 2008

I got a lot of questions from developers about SSMS 2008 error. Error message generates while saving any changes from designer studio from SSMS table designer.

Here is the solution for that.

We need to setup properties for Management Studio and then we can make changes to our table through designer.
Go to Tools -- > options.

 
click designer tab and check "table and designers tab" on left side we have following options.
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
un-check prevent saving changes that require table re-creation and click Ok.
 
you can also use other powerfull features like create change script is one.
 
cheers:)