SQL SERVER – HOW TO DISABLE SAVING CHANGES NOT PERMITTED

Varun R

In SQL Server 2008 , While you creating a table or altering any table objects you may come across this dialog box.

 

  •     In SSMS GO to TOOLS->OPTIONS

  •  An options window will open up. In that select designers and remove tick from the checkbox for Prevent saving changes that require table re-creation.

print

3 thoughts on “SQL SERVER – HOW TO DISABLE SAVING CHANGES NOT PERMITTED”

  2. Author’s gravatar

    Thanks Varun…I too have same problem while altering a table objects,good solutions..Hoping this kind of needful posts from u..

    1. Author’s gravatar

      Sure Preethy I will….!waiting for new enthusiastic questions..

      Reply
  3. Author’s gravatar

    I want to post quick hello and want to say appriciate for this good article. KxBWWQPAOTXn1M

Leave a Reply

Your email address will not be published. Required fields are marked *


6 − two =