Hot File

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode

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

7 point/5 review File has been tested

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.

Introduction

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

Cannot Alter Microsoft SQL Server 2008 Table Object in Design Mode Posted on 21-03-2014  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. 1.4/10 2005

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

    View: 1836    Download: 2   Comment: 0   Author: none  

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

    Category: Design Ideas
    Fields: Other

    2.25/2 review
    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

    View: 1384    Download: 0   Comment: 0   Author: none  

    A Quick Look at API Design

    Category: Design Ideas
    Fields: Other

    0/0 review
    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

    View: 2417    Download: 0   Comment: 0   Author: none  

    User-driven applications

    Category: Design Ideas
    Fields: Other

    0/4 review
    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

    View: 2960    Download: 3   Comment: 0   Author: none  

    A Reflective and Translucent Glass Panel

    Category: Design Ideas
    Fields: Other

    0/7 review
    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

    View: 4013    Download: 5   Comment: 0   Author: none  

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

    Category: Design Ideas
    Fields: Accounting

    0/7 review
    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

    View: 6315    Download: 2   Comment: 0   Author: none  

    Validators for Windows Forms - ValidationProvider Control

    Category: Design Ideas
    Fields: Accounting

    0/9 review
    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

    View: 1817    Download: 0   Comment: 0   Author: none  

    Integrating Help In Your Iron Speed Designer Application

    Category: Design Ideas
    Fields: Computers - Technology

    0/3 review
    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

    View: 1006    Download: 0   Comment: 0   Author: none  

    Dependency Inversion Principle and the Dependency Injection Pattern

    Category: Design Ideas
    Fields: Computers - Technology

    0/2 review
    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...

 
Newsletter Email

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd