Loading...

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

View: 2183    Dowload: 0   Comment: 2   Post by: naruto   Category: Design Ideas   Fields: Computers - Technology

Overview

Couple of week ago, I saw some posted messages not only at CodeProject but also on some other technical database forums; most of the posted message were like "Cannot alter Microsoft SQL Server 2008 Object (design mode)". So I thought that the solution should be shared with you although it's a very effortless way to do.

This article is not about sharing some programming ideas / concepts and some excellent code snippets. It's about sharing the necessary settings that you need to change to work in design mode simply as you did in Microsoft SQL Server 2000.

Solution

As we discussed earlier about the dilemma, actually this is not a problem, but some times it seems to me that it just creates a little panic when working with database object in design mode.  The following figure - A shows the warning message if your SQL Server 2008 has the default settings, and figure - B shows the Option window of SQL Server 2008.  

 

Figure - A  

Well let’s start….. To change the settings, you need to follow the instructions listed below.

Step(s)

  • Open Microsoft SQL Server 2008, Click on the tools menu and select Options.
    A window will appear with the various SQL Server settings options.

     
  • Select the Designers node and after that, click on the Tables and Database Designer sub node. Here you will find some option of a Table. The following figure - B shows the general options of SQL Server database Table object.

    Figure - B
  • You will find a checkbox (marked in orange color) named “Prevent saving changes that require table re-creation”. By default, the value of the checkbox is checked. You just need to uncheck the checkbox, that’s all.

For more information about the warning message can  be found at

Conclusion  

I hope that this might be helpful to you. 

History

  • 16th October 2009: Initial post

License

This article, along with any associated source code and files, is licensed under

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

Is your email address OK? You are signed up for our newsletters but your email address is either unconfirmed, or has not been reconfirmed in a long time. Please click here to have a confirmation email sent so we can confirm your email address and start sending you newsletters again. Alternatively, you can update your subscriptions.

Posted on 21-03-2014 

Comment:

  • @ admin - 10:51, 24/03/2014

    i see; tested

  • @ sonbka04 - 10:47, 24/03/2014

    How wonderful!

To comment you must be logged in members.

Files with category

  • MasterPages reinvented - a Component Based Template Engine for ASP.NET

    MasterPages reinvented - a Component Based Template Engine for ASP.NET

    View: 2024    Download: 2   Comment: 0

    Category: Design Ideas     Fields: Other

    A template engine allows you to render the contents of your ASP.NET web forms as parts of a Master Page (template). This template engine provides a new approach regarding the separation of ASP.NET templates and web forms. The features at a...

  • A Quick Look at API Design

    A Quick Look at API Design

    View: 1681    Download: 0   Comment: 0

    Category: Design Ideas     Fields: Other

    Whether you know it or not, you are an API (Application Programmer Interface) designer. Every time you create a new class or enhance an existing one, the non-private methods and properties create, or add to, an API. So it makes sense, I think, to...

  • User-driven applications

    User-driven applications

    View: 2694    Download: 0   Comment: 0

    Category: Design Ideas     Fields: Other

    This is the second article in a series of two. The first article – on the theory of moveable objects – was about the basic algorithm and its use in designing different moveable / resizable objects. Such objects are in high demand in many programming...

  • A Reflective and Translucent Glass Panel

    A Reflective and Translucent Glass Panel

    View: 3164    Download: 3   Comment: 0

    Category: Design Ideas     Fields: Other

    This component is the logical suite of the AlphaGradientPanel published here on CodeProject. It replaces the original System.Windows.Form.Panel by a nifty glassy one.

  • Distributed Command Pattern - an extension of command pattern for connected systems

    Distributed Command Pattern - an extension of command pattern for connected systems

    View: 4268    Download: 5   Comment: 0

    Category: Design Ideas     Fields: Accounting

    Distributed Command Pattern is a proposed pattern for solving the extra architectural design issues which need to be considered for connected systems than designing regular applications. The goal of this pattern is to “Have the same design for both...

  • Validators for Windows Forms - ValidationProvider Control

    Validators for Windows Forms - ValidationProvider Control

    View: 6566    Download: 2   Comment: 0

    Category: Design Ideas     Fields: Accounting

    Do you spend most of your time writing custom validations on Windows Forms? Have you ever wanted an equivalent WinForm validator like in WebForm? Noogen ValidationProvider can help you speed up your WinForms design time by providing powerful, easy...

  • Integrating Help In Your Iron Speed Designer Application

    Integrating Help In Your Iron Speed Designer Application

    View: 2112    Download: 0   Comment: 0

    Category: Design Ideas     Fields: Computers - Technology

    This article is in the Product Showcase section for our sponsors at CodeProject. These reviews are intended to provide you with information on products and services that we consider useful and of value to developers.

  • Dependency Inversion Principle and the Dependency Injection Pattern

    Dependency Inversion Principle and the Dependency Injection Pattern

    View: 1181    Download: 0   Comment: 0

    Category: Design Ideas     Fields: Computers - Technology

    Everyday we write lots of code which are tightly coupled and when complexity grows code will eventually deteriorate into Spaghetti Code. Which violates the Dependency inversion principle. In software design, tight coupling is often considered to be a...

 
File suggestion for you
Loading...
File top downloads
Loading...
Loading...
Codetitle - library source code to share, download the file to the community
Copyright © 2018. All rights reserved. codetitle Develope by Vinagon .Ltd